I have a Query that loads to a table as is part of a Data Model.
Often whe I refresh All the Table does not refresh (the data is unchanged even though teh source is changed.
if I close the workbook and reopen it and then go Refresh All or just Refresh the Query that loads to the Table the table refreshes. The Properties for the Query Include use Refresh this connection on Refresh All and Load Fast Data.
Any ideas how to get it to refresh using Refresh All everytime ?