View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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?