Forum Discussion

chaytho's avatar
chaytho
Copper Contributor
Nov 12, 2019
Solved

Notification of error in formula reference, but can't find error

I have a kinda complex workbook -- lots of simple formulas, multiple sheets and charts, but nothing too crazy. I keep getting an error message about a problem with a formula reference. I've gone thro...
excel
Formulas and Functions
  • Randy Birch's avatar
    Randy Birch
    Nov 12, 2019

    Try looking for the error in Conditional Formatting > Manage Rules.  A PITA as you have to look through each rule for an error, since it won't have any indication it's incorrect.  Plus can only do a sheet at a time.  But generally if you can't find an error when Excel says its there, that's the place to look.

     

    Also, check in Name Manager on the Formulas page, especially if you copied data from one workbook to another.

Patrick2788's avatar
Patrick2788
Silver Contributor
Nov 12, 2019

chaytho 

Run Workbook Analysis in the Inquire menu.

Randy Birch's avatar
Randy Birch
Brass Contributor
Nov 12, 2019

 

Patrick2788 

 

I have 365 Home and no Inquire add-in is available. …. "Inquire is only available in the Office Professional Plus and Office 365 Professional Plus editions. If you don't see an entry for Inquire Add-in in the COM Add-Ins dialog box, it's because either your edition of Office or Excel doesn't include it...."

 

 

 

Resources