ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't stop Excel 2007 from updating links (https://www.excelbanter.com/excel-discussion-misc-queries/182746-cant-stop-excel-2007-updating-links.html)

pe ken

Can't stop Excel 2007 from updating links
 
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

If you haven't already found an answer...
 
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.


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com