Invalid External Reference to a Worksheet

tmarkb

New Member
Joined
Oct 22, 2002
Messages
2
Every time I move a section of text and numbers in a specific worksheet I get the following error. "Your formula contains an invalid external reference to a worksheet. Verify that the path, workbook, and range name or cell reference are correct, and try again."

I can't find the error, any help would be appreciated.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
have a look in "links" to see if you have any old references / workbooks still being used in the workbook (you may not even know they're there).
 

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
not trying to be a pain in the *** but the formulas work before you move them? And the sheet references, workbook references all exist?

Mail me the workbook if you want and I will take a look.
 

Forum statistics

Threads
1,144,220
Messages
5,723,091
Members
422,477
Latest member
pete101

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