Works: Formula in Cell Changes During Sort Operation (265917)

The information in this article applies to:

Microsoft Works 6
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:

Start Works Spreadsheet, and then open your file.
Select the cell that contains the formula.
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.

Modification Type:	Major	Last Reviewed:	9/22/2003
Keywords:	kbbug kbpending KB265917