Add problem in QP 10

I have a tax spreadsheet I have used for several years with perfect results.

Suddenly one column refuses to add correctly.  The cents col always has an 
extra cent, or in one case 41cents off.  I take the same numbers (hard 
coded, not summed) and add them in a separate section, and they add 
correctly,

Some of the fields are positive, some negative.  Some are the result of 
several "+a+b+c", etc.   Corrupted spreadsheet?   Start from scratch? 
Hate 
to do that and lose all my charts.

I know I'm in the QP ELEVEN area, but can find NO forum for QP TEN.

I'm a relatively low key user,

Thanks,

Bill Brook, San Diego 

Bill:
> I have a tax spreadsheet I have used for several years with perfect
results.
> Suddenly one column refuses to add correctly.  The cents col always has an

> extra cent, or in one case 41cents off.  I take the same numbers (hard 
> coded, not summed) and add them in a separate section, and they add 
> correctly,

Oh dear.-(}

Usually such glitches  occur because an e.g: @SUM() refers to more than the 
user believes. The first thing to do is to check this, perhaps using [F2] or 
Tools|Auditing|...Precedents, all the way back to the first-level Cells. You 
can use View|Toolbars|[x]Auditing Tools.
 
> Some of the fields are positive, some negative.  Some are the result of 
> several "+a+b+c", etc.   Corrupted spreadsheet?

If the first idea casts no light, then this does seem very likely. 
Multiplication and division of currency values can produce unexpected results, 
but simple addition does not, unless your tax affairs rival NASA's.

It is not a good idea in principle to use the same file repeatedly for this 
sort of thing, because the more Saves there are, the more chances of a glitch. 
And I think it is possible for a little corruption to occur that does not at 
once evidently sabotage a file but has consequences that eventually do become 
apparent. Well, there has to be a reason that when one file of mine went south 
none of the ten backups was reliable either.

You can create a template/skeleton file and then [Open as Copy] each year.


> Start from scratch?  Hate 
> to do that and lose all my charts.

You can Copy Charts from Notebook to Notebook, later changing the Source Data.
Of course you can copy whole chunks of formulae also. Take care that this does 
not create false references, e.g: to Renamed Sheets that have not been 
renamed. I suppose that you would not copy the section that is misbehaving.

Before going that far, you could try in a new, blank Notebook: Insert|File. 
Sometimes this cleans things up.
 

> I know I'm in the QP ELEVEN area, but can find NO forum for QP TEN.

Try: corel.quattropro_older_versions (but for now you're OK).
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)