can't update links...can't find links

G

GJR3599

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?
 

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

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Linking data in MS Word into Excel 5
Wits end wrt automatic linking 3
Links between workbooks 3
Link won't break in Exel. 2
Workbook links 2
fixing links to external files if status shows OK 4
Linking workbooks: links not live 0

Top