Finding one or more "Invalid References" in big spreadsheet

B

Brian - FM

I need help with an automatic way to find the one or more formulas in a large
spreadsheet that have "invalid references". Is there a tool or method to
easily find the offending formula(s)?

I have a rather large workbook that has many pivots and a summary scorecard
tab that has approx 5000 formulas in it. I received an error when saving
this workbook as follows: "A formula in this worksheet contains one or more
invalid references. Verify that your formulas contain a valid path,
workbook, range name and cell reference."

Thanks,
BAM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top