Does the status bar display Circular by any chance with an unusually large
iteration value? A circular reference could produce some unexpected results?

In the example you have the formula c3+c4=c7, what's in C7? A value? A
formula or external reference to another workbook?

Soryy, I can't think of anything else that might be producing wonky values
each time you save and reopen.

Stuff like this always seems to happen on either Friday afternoon or Monday
morning.
Good luck

--
Kevin Backmann


"Steph" wrote:

It is mainly the total column that is printing incorrect information. So
c3+c4=c7, we've double checked the formula and the answer, it's all correct.
The number shown is correct, but then it won't PRINT the same number. It's
very strange..

"CLR" wrote:

Do the errant cells contain some types of formulas that might increment each
time the file is saved?.....or do they depend on data retireved from another
source?

Vaya con Dios,
Chuck, CABGx3



"Steph" wrote:

Thank you, but we've also done this. The exact view prints, only 4 cell
amounts "somehow change" when it is printed, however, on the screen it shows
differently.

"CLR" wrote:

Check the "Print Area" and if necessary re-set it.........you may not be
printing the area that you are seeing on the screen.

Vaya con Dios,
Chuck, CABGx3



"Steph" wrote:

I'm trying to help my boss w/this.

The spreadsheet she sees on her screen prints different data. It doesnt say
any of the formulas are incorrect.

It will say 1,709 on her screen and print something like 1,300 after the
document has been saved, has excited excel and reentered. Any ideas?