"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
John CarneyReliability Business Tools Analyst IIAsked:
Who is Participating?
 
Rory ArchibaldCommented:
Do you have any charts in the workbook (even if they are not on that sheet)?
0
 
John CarneyReliability 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 
John CarneyReliability 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 BrownSenior 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
 
John CarneyReliability 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
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.