#1   Report Post  
Old June 7th 05, 05:07 PM
Kimmerz321
 
Posts: n/a
Default Links updating?


I have a workbook that, once upon a time, linked to five external
workbooks. I have since cleaned up the workbook so that it only links
to one external workbook. However, whenever I open the sheet and am
prompted to update the links, it tells me that one of my links won't
update. When I click into the list of links (which now only has the
link to the one external workbook that I am still linking to), it says
the status is ok, and if I update them through that box, I get no
errors. Any idea how I can get it to stop telling me there is an error
if there is not?


--
Kimmerz321
------------------------------------------------------------------------
Kimmerz321's Profile: http://www.excelforum.com/member.php...o&userid=24105
View this thread: http://www.excelforum.com/showthread...hreadid=377114


  #2   Report Post  
Old June 7th 05, 07:00 PM
Dave Peterson
 
Posts: n/a
Default

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Kimmerz321 wrote:

I have a workbook that, once upon a time, linked to five external
workbooks. I have since cleaned up the workbook so that it only links
to one external workbook. However, whenever I open the sheet and am
prompted to update the links, it tells me that one of my links won't
update. When I click into the list of links (which now only has the
link to the one external workbook that I am still linking to), it says
the status is ok, and if I update them through that box, I get no
errors. Any idea how I can get it to stop telling me there is an error
if there is not?

--
Kimmerz321
------------------------------------------------------------------------
Kimmerz321's Profile: http://www.excelforum.com/member.php...o&userid=24105
View this thread: http://www.excelforum.com/showthread...hreadid=377114


--

Dave Peterson
  #3   Report Post  
Old June 8th 05, 09:53 PM
Mary C
 
Posts: n/a
Default

WOW, this is exactly the same problem I am having and just posted! I sure
hope someone comes up with a solution - it is driving me nuts.

"Kimmerz321" wrote:


I have a workbook that, once upon a time, linked to five external
workbooks. I have since cleaned up the workbook so that it only links
to one external workbook. However, whenever I open the sheet and am
prompted to update the links, it tells me that one of my links won't
update. When I click into the list of links (which now only has the
link to the one external workbook that I am still linking to), it says
the status is ok, and if I update them through that box, I get no
errors. Any idea how I can get it to stop telling me there is an error
if there is not?


--
Kimmerz321
------------------------------------------------------------------------
Kimmerz321's Profile: http://www.excelforum.com/member.php...o&userid=24105
View this thread: http://www.excelforum.com/showthread...hreadid=377114


  #4   Report Post  
Old September 1st 05, 01:31 PM
planner in Maryland USA
 
Posts: n/a
Default

Try this:
Open Excel. Under Tools-Options-Calculation, select the Update remote
references box.
Open your workbook. Make sure the box (in above path) is checked. save your
workbook this way after updating the link.
Close workbook and Excel.
Restart Excel and open your workbook. This process worked for someone at
our plant with this exact problem. If you still get the same error, look
under defined names and delete all that you don't need or that have broken
formulae. Run a FindLink if this doesn't clear up the trouble.

"Kimmerz321" wrote:


I have a workbook that, once upon a time, linked to five external
workbooks. I have since cleaned up the workbook so that it only links
to one external workbook. However, whenever I open the sheet and am
prompted to update the links, it tells me that one of my links won't
update. When I click into the list of links (which now only has the
link to the one external workbook that I am still linking to), it says
the status is ok, and if I update them through that box, I get no
errors. Any idea how I can get it to stop telling me there is an error
if there is not?


--
Kimmerz321
------------------------------------------------------------------------
Kimmerz321's Profile: http://www.excelforum.com/member.php...o&userid=24105
View this thread: http://www.excelforum.com/showthread...hreadid=377114




Reply
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
not updating links in excel 2003 Tony Excel Worksheet Functions 0 February 11th 05 09:57 AM
links not updating although autocalc is On? Hoochi Coochi Man Excel Discussion (Misc queries) 3 January 14th 05 12:04 AM
Updating links to new workbook with same format Andy Links and Linking in Excel 1 January 12th 05 08:22 AM
Updating links Brian Excel Worksheet Functions 1 January 12th 05 03:05 AM
Updating Automatic links doesn't work with arrays Mats Samson Excel Discussion (Misc queries) 0 December 18th 04 03:17 PM


All times are GMT +1. The time now is 04:29 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017