User is not prompted to update links when opening spreadsheet

[Wendy]

We are having difficulty getting the prompt to appear to ask the user whether
they want to update links in the spreadsheet or not. This was a feature used
in Excel 2003 but doesn't seem to work properly in Excel 2007. They either
update automatically, we have to select Data\Edit Links\update values, or
they are updated if we get the security warning that external content has
been disabled and we select Enable this content. We have tried the
following in various combinations:

1) Made sure that "Ask to update automatic links" was checked
2) tried it with "Update links to other documents" checked and unchecked
3) Trust Center settings\External Content\"Enable automatic update..."
4) Trust Center settings\External Content\"Prompt user on automatic update..."
5) Trust Center settings\External Content\"Disable automatic update..."
6) Made sure that only one spreadsheet was open at a time.
7) Data tab\Edit Links\Startup Prompt\"Let users choose to display the alert
or not"
8) Data tab\Edit Links\Startup Prompt\"Don't display the alert and don't
update..."
9) Data tab\Edit Links\Startup Prompt\"Don't display the alert and update
links"
10) Excel Options\Calculation Options - tried both manual and automatic.

Please let me know if you have a solution so that the user is notified that
there are links in the document to be updated and if they want to choose to
do it now.

Thanks.

 

[sameoldcalvin]

try this...

select
option->advanced->when calculating this workbook-> save external links
values

if you dont save the external values, the excel would need to get the
values from the external links everytime, thus getting the most
updtaed data automatically

 

[Wendy]

I did try that option both checked and unchecked, but the result was the
same. Thanks for your help.