Random #NAME? Error

[gtbear]

Hi Everyone.

I have a spreadsheet in 2003 which has been working fine for ages. It contains numerous Named cells. Suddenly now when I open the spreadsheet a couple of the cells display #NAME?. When I double click on the cell or recalculate the spreadsheet (F9) it clears and the correct result is shown. I then save the sheet and close it.
Next time I open it again the #NAME? error is back, but again only in a few of the cells.

Help!! It's driving me insane that I cannot find a solution to this.

[arthurbr]

Maybe post a small sample sheet?

[RPickering2]

Using a function that is part of the Analysis Toolpak add-in, without the add-in being loaded

Using a name that does not exist

Misspelling the name

Using a label in a formula, without labels being allowed

Misspelling the name of a function

Entering text in a formula without enclosing the text in double quotation marks

Omitting a colon ( : ) in a range reference

Referencing another sheet not enclosed in single quotation marks.

I searched the internet and there the reasons that came up. If you already checked these i'll look into it more.