Formulas Missing

[cheri312]

My formulas are disappearing in my worksheets. After working on some large
spreadsheets for my inventory; I always save and close the worksheets when I
am done. When I go back into the worksheets my formulas are missing. What or
why is this happening?

 

[Gord Dibben]

This happens on one, some or all your Excel workbooks?

You cannot save worksheets without saving the entire workbook so I assume this
is what you are doing.

When you re-open the saved workbook have the formulas changed to values or the
cells are blank like you've never been there?

Are you sure you're opening the same workbook you saved?

The behaviour you describe is not common to Excel.

Is there any code in the workbook(s)


Gord Dibben MS Excel MVP

 

[Eric]

Agreed, this is not normal Excel behavior, I think it's a file management
issue and somebody needs to stand over your shoulder to see for themselves
what exactly you're doing.

Most likely you're opening a different version than the one you saved and
not noticing it. Typically this means opening it through an e-mail
attachment, editing and saving it without realizing it's going to a temporary
folder you normally wouldn't even know existed.

Try making a few changes, then save the file to a fairly obvious place (e.g.
your desktop), right mouse-click to see the time-stamp on the file. If this
is definitely the file you just updated and the formulas aren't there, I'm
totally stumped.