Disappearing formulae
 

I recently was asked to help someone with a problem in
which, on certain sheets of a large Excel 2000
spreadsheet, every formulas had been inexplicably replaced
with seemingly random numeric constants, all in ten
decimal places. Only certain recently added pages were
affected; the original sheets, which the new sheets
summarized, were unchanged. Unfortunately, the person
didn't have a backup of the spreadsheet, but he did find
that he was able to re-enter the lost formulas by hand.
While the spreadsheet had certain macros, the person ahd
always run the sheets with them disabled, and enabling
them did not fix the problem. I was not able to determine
the cause of this.

Has anyone encountered a similar problem to this, and if
so, do they know the cause and/or any remedy for the
problem? I am not an Excel expert myself, but I suspect
that this would be a recurring problem even if the
forlumas were fixed manually.

Disappearing formulae
 

I've never seen this.

And it's difficult to believe that a user could do this without trying (but I
have seen some strange things with users, too <bg.)

Any chance you could look at the code in the macros? There are lots of requests
on how to disable a workbook after a certain time. This seems pretty mean, but
maybe....

Schol-R-LEA wrote:

I recently was asked to help someone with a problem in
which, on certain sheets of a large Excel 2000
spreadsheet, every formulas had been inexplicably replaced
with seemingly random numeric constants, all in ten
decimal places. Only certain recently added pages were
affected; the original sheets, which the new sheets
summarized, were unchanged. Unfortunately, the person
didn't have a backup of the spreadsheet, but he did find
that he was able to re-enter the lost formulas by hand.
While the spreadsheet had certain macros, the person ahd
always run the sheets with them disabled, and enabling
them did not fix the problem. I was not able to determine
the cause of this.

Has anyone encountered a similar problem to this, and if
so, do they know the cause and/or any remedy for the
problem? I am not an Excel expert myself, but I suspect
that this would be a recurring problem even if the
forlumas were fixed manually.

--

Dave Peterson