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...
Hello! I hope you still need this and that it helps. I've found the same workaround in Excel 2010 (!) and 2019. (I'm using an Italian version so I'll try to translate the corresponding English items)
__with no worksheet open__ select menu File _Options _Advanced settings
Then scroll until the end at "General" (group of items) and DE-select "Ask to update automatic links" (or similar wording) then hit "OK".
Once you have done that you can open your excel file WHILE HOLDING DOWN THE SHIFT KEY.
This will hopefully present you with the file as you last saved it (a static copy) without any update via SQL. Of course any subsequest manual update will give you an updated version of the file. And you may also need to unflag auto update every X minutes for that file.
Holding down SHIFT does not work if you don't do the previous steps, at least that's what I found.
Please note: I don't know if the above flag in Options is needed elsewhere.
__with no worksheet open__ select menu File _Options _Advanced settings
Then scroll until the end at "General" (group of items) and DE-select "Ask to update automatic links" (or similar wording) then hit "OK".
Once you have done that you can open your excel file WHILE HOLDING DOWN THE SHIFT KEY.
This will hopefully present you with the file as you last saved it (a static copy) without any update via SQL. Of course any subsequest manual update will give you an updated version of the file. And you may also need to unflag auto update every X minutes for that file.
Holding down SHIFT does not work if you don't do the previous steps, at least that's what I found.
Please note: I don't know if the above flag in Options is needed elsewhere.
The SHIFT trick is an option, i.e. the same file, as well as ALL your other files, will continue to auto update if do NOT use SHIFT on launching the file/s.
Regards
Regards