Excel links

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I have a spreadsheet with links to external files that I o
longer need. When the file opens it complains that the
links are not valid and ask if I want to browse for the
files. I'd like to remove the links to the files, but I
can seem to find if there are any cells referencing this
external file. How do I remove these links.

Thanks in advance.

Ray
 
Another way is to first go to EDIT>LINKS and then change links. When it asks
where you want to change them to, choose the file you are in. In many cases
that will keep it from looking elsewhere and it will eliminate some hidden
links.
--
RMC,CPA


I have a spreadsheet with links to external files that I o
longer need. When the file opens it complains that the
links are not valid and ask if I want to browse for the
files. I'd like to remove the links to the files, but I
can seem to find if there are any cells referencing this
external file. How do I remove these links.

Thanks in advance.

Ray
 
Back
Top