Repeating garbage in excel file, need help

  • Thread starter Thread starter David
  • Start date Start date
D

David

At work we are using Excel 2000 and have a workbook that contains several
grids. Each grid contains formulas to calculate averages and percentages.
This month after the report was completed I saved it and printed out the
grids. For unknown reasons after I saved it that day when I closed all the
grids became formatted differently, general number cells became percentage
cells and random numbers were put in place of data, I had to use last months
report to correct the report.
It's on a network drive and lots of people update it. I know that no one
did this, it was some kind of corruption. The problem is it happens every
month! The only way I've been able to stop it is to Protect the workbook
and then protect the worksheet that I just made changes to and then save.
If I don't, the cells mutate again. Does anyone know of a way to fix this
or give a reason why this would happen? Any help is appreciated,
David
 
I've never seen excel do anything like this.

And if it doesn't happen when you update the workbook, I guess the changes were
either inadvertent or on purpose.
 
Back
Top