Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 714
  • Last Modified:

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

I keep getting this alert whenever I open a series of workbooks even though a Contol-G search for formulas with errors always fails to find any. What is causing this, and how do I either fix it or suppress it, in order to keep my users from getting annoyed?

Thanks,
John
0
gabrielPennyback
Asked:
gabrielPennyback
4 Solutions
 
DaveCommented:
John,

In Xl2007 you may continue to get this message even after In Excel 2007 you have corrected for bad references and names
http://support.microsoft.com/kb/931389

You might find Mappit! useful to indentify where the formula errors (and links) are
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2613-Mappit-a-free-Excel-model-auditing-addin.html?aid=2613&titleurl=Mappit-a-free-Excel-model-auditing-addin
Dave
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello John,

if you can't find any #Ref! errors in the formulas of the cells, also check range names, data validation and conditional formats! Sometimes there's something hidden there.

cheers, teylyn
0
 
gabrielPennybackReliability Business Tools Analyst IIAuthor Commented:
Great suggestions, I'll try them out tomorrow morning, thanks.

- John
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Rory ArchibaldCommented:
If you have charts, check those.
0
 
gabrielPennybackReliability Business Tools Analyst IIAuthor Commented:
Thanks. Sorry for the delay.

- John
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now