Disappearing formulae

  • Thread starter Thread starter Schol-R-LEA
  • Start date Start date
S

Schol-R-LEA

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.
 
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
 
-----Original Message-----
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>.)
Click to expand...

While I can see a user doing this by accident to one
formula, or even one sheet, I find it hard to think that it
could be done to several pages in such a specific pattern.
I won't rule it out, however.
Any chance you could look at the code in the macros?
Click to expand...

In this case, no.
There are lots of requests
on how to disable a workbook after a certain time. This seems pretty mean, but
maybe....
Click to expand...

Well, as I said, the macros were disabled when this first
occurred, and the user only loaded it with them enabled
when trying to fix the problem. Unless they unintentionally
ran it with the enabled and didn't realise it, I doubt that
the macros were the cause.

Thank you for the advice, however.
 
One more unusual guess...
The macro doesn't have to be in the same workbook.
Any chance that the user has a malicious routine in some other workbook/addin?
 
Back
Top