automatic links

I have a workbook with many sheets in it. I've done many updates to the
file including making copies of sheets w/ links to other worksheets within
the workbook, as well as renaming the file numerous times (e.g v2, v3,
etc.). Now, each time I open the file, it asks to update automatic links
because its looking for links to a file that no longer exists because it has
been renamed to the current file.

Is there a way to find what cells are looking for the automatic updates so I
can correct this?

--

often imitated, never duplicated
niq

Dominique Feteau wrote:
Is there a way to find what cells are looking for the automatic updates so I
can correct this?

FINDLINK.XLS from http://www.BMSLtd.co.uk/mvp

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup