Wrong Data Prints

[Steph]

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?

 

[Kevin B]

Click TOOLS on the menu and select OPTIONS. Click the CALCULATION tab and
see if the MANUAL option button is selected and teh RECALCULATE BEFORE SAVE
check box has been checked. This would explain why the values don't match
after closing and reopening a file.

 

[Steph]

Hi Kevin,

We tried it. That's not what is. It wasn't set to manual, but after we
changed it the same thing happened. Everything is saved correctly, we
reenter the program and the data is correct. But when it prints, numbers are
different.

 

[CLR]

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]

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]

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]

It is mainly the total colum that has formulas entered that are causing the
problem. So c3+c4=c7, and the formula is correct/numbers match. But then
the number shown, doesn't print! It changes to something incorrect....

 

[Steph]

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]

If the sheet is a fairly simple one.........I would at this point just try
recreating it in a new workbook..........unless one of the previously
described problems exists, it should work ok.........."sometimes the Dragon
wins".....

Vaya con Dios,
Chuck, CABGx3

 

[Kevin B]

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