Invalid references in a chart

[mabelline]

I am getting the following error when I open a chart in Excel. There are multiple data points and I am having trouble pinning it down. Is there an easy way to do a search for the invalid reference?

Here is the message

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

 

[Robert Mika]

Start from defines names.
Look if they all are pointed to this workbook

(below is only an example)

if you see #REF somewhere in "Refers to" window it means that the names could be moved/pointed from/to another workbook(this workbook could be deleted) or some values have been lost(deleted cell)
You can now easy track where the errors occur.

 

[mabelline]

Thanks! I think I am close to fixing it. Can you let me know how I can pull up the "Defined Name" Dialog box?

 

[Robert Mika]

If you are XL 2003

In 2007
Formulas Tab---> Name manager