LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Excel 2007 without Updating Links TKS_Mark Excel Discussion (Misc queries) 1 September 4th 07 05:48 PM
Updating links in Excel 2002 Kim Excel Discussion (Misc queries) 0 August 17th 07 02:17 AM
Updating Links on Excel Update Link Question Excel Discussion (Misc queries) 4 May 22nd 06 08:21 PM
updating links in Excel WESTARM Excel Discussion (Misc queries) 0 March 13th 06 03:40 PM
not updating links in excel 2003 Tony Excel Worksheet Functions 0 February 11th 05 09:57 AM


All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"