Is there a setting so when an excel file is openned that has external data it won't update automatically? 2003 would prompt the user.
1 Answer
Click on Office button -> Excel Options
-> Advanced
-> Scroll down to General
and ensure Ask to update automatic links
checkbox is checked.
-
This was always confusing to me. Does it mean update without asking, or don't ask, just update, That is the setting I would like to find.– datatooOct 29, 2010 at 15:21
-
-
if that checkbox is checked, then Excel will ask if the links need to be updated, instead of updating them automatically. That's what @Jeff O wants. @data– Sathyajith Bhat ♦Oct 29, 2010 at 15:49