Identify what is linked to current spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to find out what other, if any, spreasheets are linked to the spreadsheet I am in. I am cleaning up some old files and want to delete them, but I am not sure if I had previously linked some other file to them. Any thoughts?
 
mjp116 said:
Is there a way to find out what other, if any, spreasheets are linked to
Click to expand...
the spreadsheet I am in. I am cleaning up some old files and want to delete
them, but I am not sure if I had previously linked some other file to them.
Any thoughts?

Excel pulls data from elsewhere - it doesn't push it. Therefore, there is
nothing in your currently-open file that knows what other workbooks may be
trying to pull data from it (or would if they were opened). You would need
to open each possible candidate workbook in turn and look to see if there
are any links that pull data from the one you are thinking of deleting. (In
other words, the links are to be found in the destination workbooks, not the
source one.) No doubt this could be automated with code.
 
Back
Top