asked on

"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

ASKER CERTIFIED SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Carney

ASKER

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 Archibald

Do any charts use data from that sheet?

John Carney

ASKER

The charts don't reference data from that sheet directly, but they do reference tables that get their data from that sheet.

Rory Archibald

I'd probably need to see a copy of the workbook. (No real data required!)

SOLUTION

Stacy Brown

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Carney

ASKER

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

&quot;A formula in this worksheet contains one or more invalid references&quot; error

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