Tracking Down Formula Errors

MikeG

Well-known Member
Joined
Jul 4, 2004
Messages
816
I have a very large workbook that I have inherited that has 40 sheets and many formulas, charts, and range names.

Every now and then as I move around the workbook, I get the message box that pops up to say:

"A formula in this worksheet contains one or more invalid references"

Does anyone know if there is a direct way to find out which formulas are triggering this? The only thing I can think of to do at the moment is to start deleting sheets to find the culprit sheet(s) and then delete things within the sheet(s). this could take a long time.

Also, I am pretty sure that even though the message says "in this worksheet", it can in fact pop up when you are working on a sheet that does not have any bad formulas. (Because I have had it pop up when I have been using very small simple sheets that I am 99% sure aren't causing any issues.) Can anyone confirm this.

thanks,

Mike
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,330
Office Version
  1. 365
Platform
  1. Windows
What happens in such a sheet when you click on Formulas | Formula Auditing | Error checking?
 

cw1595

New Member
Joined
Mar 9, 2016
Messages
1
I have a growing MS ACCESS Database Application - with multiple projects which is tied to multiple reports. Every time a project is updated I would like a copy of the report sent automatically as a PDF to a desired location on the internet where each project resides. Is that doable?
 

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,330
Office Version
  1. 365
Platform
  1. Windows
Please post your question in a new thread. What you ask is off topic here.
 

MikeG

Well-known Member
Joined
Jul 4, 2004
Messages
816
What happens in such a sheet when you click on Formulas | Formula Auditing | Error checking?

Thanks - I tracked my error down to a chart. But it was useful to follow you suggestion anyway.

Mike
 

Watch MrExcel Video

Forum statistics

Threads
1,122,187
Messages
5,594,753
Members
413,930
Latest member
Nela817

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