Can't stop Excel 2007 from updating links

[pe ken]

Every time I start Excel, all links update without the prompt. I need to have
the option to update or not. NOTE: I have set the following options:

Under Edit Links, Startup Prompt: Let users choose to display the alert or not

Trust Center settings, External Content: Prompt user on automatic update for
Workbook Links

Excel Options, Advanced, General: Ask to update automatic links

Also, on the "Edit Links" panel, the "Manual" Update option is grayed out,
and:

In the Excel Options, Advanced, "When calculating this workbook" area, the
"Update links to other documents" option does allow me to uncheck it, but
when I save and close and re-open, it is checked again, and:

This happens for newly created Excel 2007 workbooks as well as when I'm
opening files from earlier versions.

Help?

Side note: I'm beginning to suspect it has something to do with "Group
Policy" settings established by my system administrators, yet my helpdesk
people were also stumped.

Does this seam reasonable to anyone, that it could be a "Group Policy"
setting? (I've also noticed that every time I create a new workbook, it
automatically comes up in "compatibility mode." This may be related to my
problem and the whole "Group Policy" thing too, but I don't know.)

Any ideas?

 

[VICKI NAPIER]

I was looking for a setting to do exactly that...update upon opening without any prompt.
I found the setting under the Excel Option/Trust Center Settings/External Content.
Here there are security settings for how workbook links are updated.

 

[WesSDM]

Have the same problem as pe ken. This seems very odd - our techies have been unable to find published information on a bug of this nature, and I can't believe all Excel 2007 users have the problem.

Let me know if you get a solution!