How to find link in worksheet?

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

I'm using Excel 2002. For some reason, when I open a particular worksheet
that I work with often, I get the following popup:

The worksheet contains links to other data sources
UPDATE DON'T UPDATE HELP

This just started after cutting and copying a group of cells into another
worksheet. Any suggestions how I find out what this is and correct it?

Thanks,
Brett
 
Since Excel encloses the workbook name in square brackets [...] try searching for [ or ].
Otherwise use Edit/Links, and change the link to point to the current file itself.
 
One place where excel hides unwanted links is as a range
name. If you have ranges or cells named in one file and
you copy them to another a link is maintained to the
location in the source file. TO find these click on
Insert/Name/Define and check what location each range name
points to. You may find links.
 
Back
Top