XL2003SP2: This workbook contains one or more links that cannot be updated. "Ronald R. Dodge, Jr." <rdodge1[ at ]cinci.rr.com> 16.07.2006 05:14:23 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.

Re: XL2003SP2: This workbook contains one or more links that cannot be updated. "Alan" <alan111[ at ]ntlworld.com> 16.07.2006 09:59:16 Try this, download FindLink.zip from Bill Manville, http://www.oaltd.co.uk/MVP/Default.htm Regards, Alan. "Ronald R. Dodge, Jr." <rdodge1[ at ]cinci.rr.com> wrote in message news:OJqszaJqGHA.148[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > 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. >

Re: XL2003SP2: This workbook contains one or more links that cannot be updated. Dodgester <Dodgester.2b2sy6[ at ]mail.mcse.ms> 17.07.2006 04:50:45 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 ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message2420970.html