Wrong Data Prints
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.
--
Kevin Backmann
"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?
|