Cannot Find All Links

easyman

New Member
Joined
Nov 25, 2005
Messages
1
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?
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

thunderfoot

Board Regular
Joined
May 28, 2004
Messages
229
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,702
Members
412,481
Latest member
nhantam
Top