Microsoft KB Archive/265917

= Works: Formula in Cell Changes During Sort Operation =

Article ID: 265917

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * Microsoft Works Suite 2001
 * Microsoft Works 7.0
 * Microsoft Works Suite 2002
 * Microsoft Works Suite 2003

-



This article was previously published under Q265917



SYMPTOMS
When a cell in the column of your Microsoft Works Spreadsheet document contains a formula, and you then click Sort on the Tools menu, the formula in the cell may change during the sort operation.

For example, if you type the following data in your spreadsheet   A1   A2   A3   1    1    =sum(A1:A2) and then sort column A in the descending sort order, the sort operation moves the formula to cell A1 and the formula changes to the following:

=SUM(A16383:A16384)



CAUSE
This problem can occur because the Sort command does not modify the formula to reflect the new cell range.



RESOLUTION
To work around this problem, you have to manually modify the formula after you perform the sort operation. To do so, follow these steps:
 * 1) Start Works Spreadsheet, and then open your file.
 * 2) Select the cell that contains the formula.
 * 3) Manually modify the formula to reflect the new cell range.



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

Keywords: kbbug kbpending KB265917

-

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

© Microsoft Corporation. All rights reserved.