Microsoft KB Archive/272264

= Works: AutoSum Does Not Recalculate Sum of Column =

Article ID: 272264

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 6.0
 * Microsoft Works Suite 2000
 * Microsoft Works Suite 2001
 * Microsoft Works 7.0
 * Microsoft Works Suite 2002
 * Microsoft Works Suite 2003

-



This article was previously published under Q272264



SYMPTOMS
The sum of a column within Microsoft Works Spreadsheet may be incorrect.



CAUSE
This problem may occur if you use the AutoSum function to total the column, and then use a copy and paste operation to copy a number from another spreadsheet into a cell in that column.



RESOLUTION
To work around this problem, double-click the AutoSum formula in the cell that contains the sum of the column to automatically recalculate the sum of the column, or edit the numbers manually.

To edit the numbers manually, follow these steps:
 * 1) Click to select the cell in which you want to change the number.
 * 2) Type the number that you want in the selected cell, and then press ENTER.

The AutoSum function automatically recalculates the sum of the column.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: w_works works2k w2001 works6 wksss auto sum addition total

Keywords: kbprb kbui KB272264

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.