If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|