Why doesn't Excel 2007 automatically update links in Trusted Files

  • Thread starter whydoyoumakethingsoverlycomplicated
  • Start date
W

whydoyoumakethingsoverlycomplicated

I have a number of workbooks that are all linked to each other.
I also occasionally open other workbooks that have links but I may not want
to upadate these.
In 2003 I could manually set each workbook to update the links so only the
ones I wanted would update the links when opened, but others would not.
So I had a choice.
Now the only choice I have is to update all links (apparently not
recommended) or to have Excel ask me to update for every file, which is
really no choice at all.
All the files I want to update are in my Trusted Locations, so why is there
no option to automatically update the links in files or to files that are in
Trusted Locations?
What is the point in developing this Trust Centre if it doesn't work for the
user, but works against them instead, making things difficult and bombarding
them with prompts everytime they open a file with links in it??

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...5-0aeceb039156&dg=microsoft.public.excel.misc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top