Formula with Invalid References Error Message

[DOUG]

I am unable to save a spreadsheet in the ".xlsx" format, but able to save it
as ".xls". The "xlsx" save attempt yields an error 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." I
have tried looking at the formulas. There are only two and they are very
simple and display no errors when selected. (I have tried selecting F5 (Go
to Special) and "Formulas>Errors, etc.", to no avail, too). What is going on?

DOUG ECKERT

 

[David Biddulph]

I would suggest that you post the formulae here if you want advice.

 

[Don Guillett]

Always nice to show us the formulas for comments.

 

[DOUG]

The formulas were nothing more than addition and they worked, with no errors.
Somehow, the anomaly resolved itself. But, thank you.

(There was nothing to show, in other words. The so-called error made no
sense and went away by itself, eventually).

DOUG

 

[patrick williams]

The formulas were nothing more than addition and they worked, with no errors.
 Somehow, the anomaly resolved itself.  But, thank you.

(There was nothing to show, in other words.  The so-called error made no
sense and went away by itself, eventually).

DOUG

I just ran into this one myself. I had removed a section of a
worksheet that had links to another worksheet and a chart.

After deleting all references to those sections I saved (.xlsx) and
received the same message. Searched everywhere to no avail for
formula errors.

However, I did notice the workbook did save, so, I closed the file,
reopened the saved version and I'm no longer receiving this error.
Not sure if this matters but the workbook started as an Excel '03 file
then was saved up to .xlsx about three revisions ago.

I think this is a bug of the "wild goose chase" variety.

Skip

 

[patrick williams]

I just ran into this one myself.   I had removed a section of a
worksheet that had links to another worksheet and a chart.

After deleting all references to those sections I saved (.xlsx) and
received the same message.   Searched everywhere to no avail for
formula errors.

However, I did notice the workbook did save, so, I closed the file,
reopened the saved version and I'm no longer receiving this error.
Not sure if this matters but the workbook started as an Excel '03 file
then was saved up to .xlsx about three revisions ago.

I think this is a bug of the "wild goose chase" variety.

Skip

Retraction from my last post. It turns out that the references were
for the names of data series on existing charts that previously
references my deleted data. The data series were still valid but the
names of the series reflected #REF errors. Compounding this were
multiple charts that were also hidden worksheets but still have the
#REF errors.