Cannot Find All Links

[easyman]

Hi

I have copied three sheets from one workbook into another and cannot update the links associated with the pages I have copied.

When I try and change the source of the links I get the following error message;
Your formula contains an invalid external reference to a worksheet.
Verify the path, workbook, and range name or cell reference are correct and try again.

I have verified these and still cannot change the source

I have also tried searching for the link using the search function in formula and cells and connot find where the link is

Please please does anyone have any ideas?

 

[thunderfoot]

I think I understand your question.

If the links start C:\, then do a search using that on all the worksheets to make sure you find them all.