Forum Discussion
Disable automatic updates of excel file
Hi, I have an Excel file that automatically updates from different data connections (SQL) when users open it. However I want to save an static copy that does not update to latest data when it is op...
Thank you, but I can not locate above view in my Excel?
I have 7 queries in the Excel sheet that are used by 30+ pivottables.
I have 7 queries in the Excel sheet that are used by 30+ pivottables.
Kasper22 What are your query load options, you load query to data model only ?
- Yes the queries are loaded only to the data model
When simply disable all refresh options, includes Refresh All, in the final file.