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.
Click on Office button -> Excel Options -> Advanced -> Scroll down to General and ensure Ask to update automatic links checkbox is checked.
Ask to update automatic links
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
5 years ago