Formula Contains One or More Invalid References ??

[monirg]

Hello;

I've looked at similar threads here and elsewhere, but couldn't find a solution that successfully applies to the problem .

1) I have a simple w/b consisting of 2 w/s and 2 Line charts (each in its own sheet).
NO VBA and NO links are used.

2) The w/b works fine with all its functionality intact.
One exception:
...menu "Save" works fine
...menu "Close" works fine
...menu "Exit" produces the message:

A formula in this worksheet (named "Data") contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range name, and cell reference.

3) There're NO formulas on this w/s "Data":
...Edit::Go To::Special::Formula
...returns: No cells were found.
and all range names are checked/correct.

Could someone please advise on how to identify this "formula with invalid references on this worksheet" ??

Regards.

 

[RoryA]

If you create a copy of the workbook, remove all the charts and save it, do you get the same error?

 

[Norie]

Monir

Where exactly did you look for code?

Instead of emailing the workbook upload it to a file sharing site and post a link here.

 

[monirg]

Monir wrote (reply # 9):
Deleting any 3 of the 4 sheets, does not change the situation.

Rory wrote (reply # 11):
If you create a copy of the workbook, remove all the charts and save it, do you get the same error?

YES.

Norie wrote (reply # 12):
Where exactly did you look for code?
Instead of emailing the workbook upload it to a file sharing site and post a link here.

There's NO (user) VBA code in the w/b. The data for the Charts is tabulated in the 1st w/s "Data".
I prefer to email a copy to a trusted individual(s) than uploading it to a file sharing web site.

Regards.

 

[RoryA]

Do you have any named ranges in the workbook?

 

[monirg]

Rory wrote (reply # 14):
Do you have any named ranges in the workbook?

Yes, quite a few. Checked many many times.
The full functionality of the w/b (in XL 2003) remains intact even with the "invalid references ..." message!
Furthermore, the "XL 2003 problem file" runs As Is without a hitch in XL 2007.

Regards.

 

[Norie]

Monir

Can you upload the file?

 

[monirg]

Norie;

Can you upload the file?

I prefer to email a proprietary copy rather than uploading it to a file sharing web site.
Please let me know by a PM.

Regards.

 

[RoryA]

I can't actually replicate your error, but you have 4 invalid global names:
sCol, sRow, ColumnData and RowData all have #REF! errors in them.

 

[monirg]

Hi Rory;

I can't actually replicate your error, but you have 4 invalid global names:

sCol, sRow, ColumnData and RowData all have #REF! errors in them.

The mystery deepens even further!

In the file I emailed you:
...Insert::Name::Define::
selecting each name in the "Names in Workbook", and going to "Refers To:"
highlights the correct range for that name
There's NO #REF! anywhere, and the w/b works perfectly (apart from the error message on Exit in XL 2003).

I'll shortly email you another copy of the problem file, just in case!

Regards.

 

[RoryA]

Select one of the chart sheets, then bring up the names dialog and you will see what I mean.