Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / July 2006

Tip: Looking for answers? Try searching our database.

XL2003SP2: This workbook contains one or more links that cannot be updated.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ronald R. Dodge, Jr. - 16 Jul 2006 06:14 GMT
How do I get rid of the above error message when I open the workbook?

I have tried unchecking the "Update remote links" and then save the file,
close it out and close out of Excel, then reopen the file only to find that
the file has that optioned checkmarked once again.  I want to get rid of
this error message as it's so much of an annoyance, why should I have to
click on it every single time when I go to open my 4 financial files, which
I updated at the minimal once a week, and generally more like daily unless
I'm on vacation or I got to be so busy that I haven't had a chance to update
it.

Sincerely,

Ronald R. Dodge, Jr.
Alan - 16 Jul 2006 10:59 GMT
Try this, download FindLink.zip from Bill Manville,
http://www.oaltd.co.uk/MVP/Default.htm
Regards,
Alan.
> How do I get rid of the above error message when I open the workbook?
>
[quoted text clipped - 10 lines]
>
> Ronald R. Dodge, Jr.
Dodgester - 17 Jul 2006 05:50 GMT
That will only go out and find the links, which prior versions didn't
have that option too readily available, thus one about had to use
macros to find external links within every single worksheet of
workbooks.  However, starting with XL2002, that option has been
available via the additional options such as look within worksheet or
look within workbook in addition to the option that has been in prior
versions, look at values or look at formulas.

I have used this tool in the past, but it doesn't address the same
issues as what I'm facing now.  The problem lies more in the fact that
Excel is trying to reach to those external sources even though the
workbooks aren't opened.  I do believe, I just found the answer to this
question, and here's the answer, though still not sure if it will keep
this result cause of it going back and forth between 2002 and 2003.

Within Excel 2003, for the impacted files, follow the steps one by
one:

Goto Edit>Links...

Click on Startup Prompts...

Select the option, "Don't display the alert and don't update automatic
links."

This seems to work within the version, but I still have yet to verify
if this works between versions.

Thanks,

Dodgester

--
Dodgester

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.