Wrong Data Prints
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
"Steph" wrote:
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....
"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?
|