Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

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

alt text

share|improve this answer
    
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 '10 at 15:21
    
seems like Not asking to update, means not updating –  datatoo Oct 29 '10 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 –  Sathya Oct 29 '10 at 15:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.