error help

[plost33]

i am working in a workbook with multiple sheets and i keep getting the following caution message box popping up as i work:

"A formula int his worksheet contains one or more invalid reference.

Verify that your formulas contain a valid path, workbook, range name, and cell refernce."



anyone know why i am getting this? i do not have any formulas that are returning an error. is there any way to check the formulas for errors?

 

[Andrew Poulsom]

Do you have any charts in your workbook?

 

[plost33]

the sheet i am working in use to have alot of chart on it but i deleted the rows they were on.

 

[Andrew Poulsom]

If you type this into the Immediate window of the Visual Basic Editor and press Enter what does it return?

?ActiveSheet.ChartObjects.Count

 

[plost33]

it say 2

 

[Andrew Poulsom]

Then you haven't deleted all the charts. Try this from the Immediate window:

activesheet.chartobjects.delete