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

I keep getting this error message whenever I run a fairly complicated macro. Among other things, rows get deleted but all of the named ranges remain intact.As far as I can tell I don't have any paths or cell references with errors. But I'm not sure what they mean by a "valid" workbook.

When I google it, everyone suggests that it has something to do with charts but I don't have any charts on the sheet in question.

Any thoughts?

gabrielPennybackReliability Business Tools Analyst IIAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Rory ArchibaldConnect With a Mentor Commented:
Do you have any charts in the workbook (even if they are not on that sheet)?
gabrielPennybackReliability Business Tools Analyst IIAuthor Commented:
Yes I do. One of the suggestions online was just to delete sheets with charts one at a time until you find the offending sheet, then do it one chart at a time. But I haven't done it because the error message doesn't always come up which would make it difficult to tell if you were getting false negatives.
Rory ArchibaldCommented:
Do any charts use data from that sheet?
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.

gabrielPennybackReliability Business Tools Analyst IIAuthor Commented:
The charts don't reference data from that sheet directly, but they do reference tables that get their data from that sheet.
Rory ArchibaldCommented:
I'd probably need to see a copy of the workbook. (No real data required!)
Stacy BrownConnect With a Mentor Senior Applications AdministratorCommented:
Seeing a copy would be helpful.  I'm betting that there is a problem between the chart and the tables that reference data from that sheet
gabrielPennybackReliability Business Tools Analyst IIAuthor Commented:
Sorry I've been gone so long. I think I'll have to revisit this question later, but in the meantime thank you for posting at all! :- )<br /><br />- Thanks, John
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.

All Courses

From novice to tech pro — start learning today.