2

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 1

3

Click on Office button -> Excel Options -> Advanced -> Scroll down to General and ensure Ask to update automatic links checkbox is checked.

alt text

3
  • 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.
    – datatoo
    Oct 29, 2010 at 15:21
  • seems like Not asking to update, means not updating
    – datatoo
    Oct 29, 2010 at 15:22
  • 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .