Help plse!

J

JJ

Here's the situation...
I have a forecast spreadsheet that I am doing and I enter in the data for each month. I have saved it. It is not linked to another worksheet so nothing should affect what I saved. However, when I go back in, the data have changed in some areas. I print it off... then close it and go back into it. Some of the values have changed again so it doesn't look exactly like the original data I typed in and also the sheet I printed out the second time I went in. Does anyone know what's going on? Why are some numbers changing when I close the file and then go back in without me doing any changes?
Any help/advice would be appreciated!
 
W

William

Have you turned off automatic calculation before you close the file. If so,
put it back on.

--
XL2002
Regards

William

[email protected]

| Here's the situation...
| I have a forecast spreadsheet that I am doing and I enter in the data for
each month. I have saved it. It is not linked to another worksheet so
nothing should affect what I saved. However, when I go back in, the data
have changed in some areas. I print it off... then close it and go back
into it. Some of the values have changed again so it doesn't look exactly
like the original data I typed in and also the sheet I printed out the
second time I went in. Does anyone know what's going on? Why are some
numbers changing when I close the file and then go back in without me doing
any changes?
| Any help/advice would be appreciated!
 
P

profwagner

Is the data really changing, or just displaying differently because of formatting. (E.g. 2.09999 would display as 2.1 if the format was set to display only one decimal place).

Just a thought.
 
Top