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?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,809
Messages
5,833,790
Members
430,233
Latest member
cbutts

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top