Locating workbook links

  • Thread starter Thread starter Jeff Cummings
  • Start date Start date
J

Jeff Cummings

How do you locate cells that are linked to another
workbook? I copied formulas and data from another
workbook into a new workbook. I did not intentionally
link any cells in the new workbook to the original. Upon
opening the new workbook file I get a message that there
are links to another workbook and the question of whether
I want to update the current workbook. I need to locate
the cells with links to eliminate the links.
 
Jeff Cummings said:
How do you locate cells that are linked to another
workbook? I copied formulas and data from another
workbook into a new workbook. I did not intentionally
link any cells in the new workbook to the original. Upon
opening the new workbook file I get a message that there
are links to another workbook and the question of whether
I want to update the current workbook. I need to locate
the cells with links to eliminate the links.
Click to expand...

An easy manual way is this:
Links to closed workbooks appear in formulas in this form:
='C:\Temp|[Book2.xls]Sheet1'!A1
So you can use Edit > Find to look for, for example, C:\
 

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
Excel Protection 2
Link behavior with changing data set 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Macro to push data to another workbook 0
Sharing workbooks limitations - Merged Cells 12
Linking workbooks together 1

Back
Top