But read http://office.microsoft.com/en-us/excel-help/control-when-external-references-links-are-updated-HP010342302.aspx#BMnoaskmanual first and try the settings as you wish.
Why do I write no? Because all the security updates tend to break things as well as hammer the users with "Are you sure?" prompts. Because MSFT and others are hammered over security they might have moved to "Well, they asked for more security, so let's be sure they are prompted over and over."
Bob
Have a small annoyance in excel 2010.
In Excel 2003, if you went to open some files, and highlighted a group of say 10 files, when the first one opened, you got a prompt saying do you want to update external ink values.
Whether you answered yes or no, the same answer would apply to the next 9 files as they open.
In excel 2010, seems I have to click 'No' 10 times.
Is there any way to stop this behaviour?
It didn't used to do it, but it has suddenly started to, and I can't stop it !!!
Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic