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:\
 
Back
Top