Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 4th 05, 04:45 PM
GJR3599
 
Posts: n/a
Default can't update links...can't find links

I have a workbook (Two.xls) that pulls data from another workbook (One.xls).
When opening Two.xls i tell it to update data, and I then receive a message
saying that there are links to other workbooks that connot be updated. When
searching for the links to this source (One.xls) I am unable to find the
links. I search for ".xls" and"[" and find nothing. I have intentional links
to One.xls so I can't just break all links, nor can I simply search and
delete all instances of .xls, however, the intentional links work correctly
(they are able to update)...is there a way to find the unwanted links even if
they don't appear when running a normal search?

  #2   Report Post  
Old April 4th 05, 04:56 PM
Bob Umlas
 
Posts: n/a
Default

Go to http://www.cpearson.com/excel/xltools.htm and download Bill Manville's
Findlink macro


"GJR3599" wrote in message
...
I have a workbook (Two.xls) that pulls data from another workbook

(One.xls).
When opening Two.xls i tell it to update data, and I then receive a

message
saying that there are links to other workbooks that connot be updated.

When
searching for the links to this source (One.xls) I am unable to find the
links. I search for ".xls" and"[" and find nothing. I have intentional

links
to One.xls so I can't just break all links, nor can I simply search and
delete all instances of .xls, however, the intentional links work

correctly
(they are able to update)...is there a way to find the unwanted links even

if
they don't appear when running a normal search?





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
Update Links JacoH Excel Worksheet Functions 1 March 8th 05 02:48 PM
Manually update links Emma Excel Worksheet Functions 0 February 22nd 05 01:23 PM
Update Automatic Links Not Working in 2003 cydkil Excel Discussion (Misc queries) 2 February 15th 05 03:35 PM
Update Individual Links mikxtr Excel Discussion (Misc queries) 3 January 21st 05 04:24 AM
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 7th 04 11:53 PM


All times are GMT +1. The time now is 01:54 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017