"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?

Thanks,
John
LVL 1
gabrielPennybackReliability Business Tools Analyst IIAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Do you have any charts in the workbook (even if they are not on that sheet)?
0
 
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.
0
 
Rory ArchibaldCommented:
Do any charts use data from that sheet?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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.
0
 
Rory ArchibaldCommented:
I'd probably need to see a copy of the workbook. (No real data required!)
0
 
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
0
 
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
0
All Courses

From novice to tech pro — start learning today.