Microsoft KB Archive/176754

= Formula Moves or Disappears When you Undo Column or Row Deletion =

Article ID: 176754

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q176754



SYMPTOMS
If you undelete one or more columns that contain a formula by clicking Undo Delete on the Edit menu, the formula in the undeleted column may move down several cells within the column.

If you then undelete one or more rows by clicking Undo Delete on the Edit menu, the formula in the undeleted column may disappear completely.



CAUSE
These problems may occur when the following conditions are true:


 * There is a numeric value in any cell in the range A18:A65536. -and-


 * The formula is located in any cell in the range B2:IV16. -and-


 * You delete any row from row 1 through row 16 (inclusive) by selecting the row and clicking Delete on the Edit menu. -and-


 * You then delete the column that contains the formula by selecting the column and clicking Delete on the Edit menu.

When you undelete the column, the formula moves down within the column to row 16 (for example, from B3 to B16). When you undelete the row, the formula disappears completely.



WORKAROUND
Do not undelete columns or rows that contain formulas when the conditions in the "Cause" section are true.

To work around these problems, you must manually correct the formulas in the worksheet. If you have previously saved the workbook, you may be able to close the workbook without saving changes, and then reopen the workbook.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

Additional query words: XL97 undo deletion udno redo add back XL

Keywords: kbprb KB176754

-

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

© Microsoft Corporation. All rights reserved.