Identifying cells linked to other workbooks

R

routeram

Hi,

This seems simple but I can't figure out how. I copied certai
worksheets from a workbook to a new workbook. Now, when I open th
copied version, Excel tells me that the copied one is linked to th
original version of the file.

I want to see the cells that refer to the original workbook. I trie
clicking the Name box and also Insert -> Name -> Define to see what th
references are but I can't see any such reference.

As far as I know, I copied all the required information. So ther
should be no references to the original version.

Thanks
 
B

{*BoB*} OZZIE

Sounds like the sheet that you copied to the new workbook
had a cell or group of cells that took information from
another sheet within the original workbook (in sheet1,
a2=sheet2!a4).

try doing a find using some or all of the file name of the
original file to find out where the formula is. Then make
your adjustments.

FYI - Under edit / links, your original file should be
listed as a source file.

HTH.
 
Top