Hi Catalin/Mynda!
I have a set of 9 quires in my spreadsheet which retrieve data from SQL server database (thanks to you guys).
I update the spreadsheet daily and it takes 10-15 min of waiting.
I'd like to shorten the update time and the first thought came up in my mind was to disable the update of some queries which I need to update monthly only.
So I'd like to disable updating of 5 queries and enable them only when I need it (basically once a month or as per necessity).
Is it any possibility to do so?
I mean, I want to click the Refresh button once and it makes refresh only those queries I haven't disabled.
I know that it is possible to update those 4 queries separately by clicking Refresh buttons on the Workbook Queries pane one by one but the users of the spreadsheet requested me to create "one button click" spreadsheet.
Thank you in advance!
Hi Oleg,
To disable refresh only for specific queries, go to Data>Connections, locate the connection that you want to disable, click on Properties, then uncheck the option "Refresh this connection on Refresh All". You will have to update them manually when needed.
Hi Catalin,
thank you so much!
