Excel: Cell Note Reference Gets Corrupted After Sort

 Last reviewed: November 30, 1994
Article ID: Q80227
Summary:

In Microsoft Excel, if a cell with an attached cell note and a thick border style is relocated during a sort, all cell note references in the sorted area become corrupted. The damaged reference has the correct column but a row number above 49,000.

Workaround

When sorting cells with attached notes and thick borders, format the cells for no borders or a different border style.

Microsoft has confirmed this to be a problem in Excel for the Macintosh version 3.0 and Excel for Windows version 3.0. We are researching this problem and will post new information here as it becomes available.

More Information:

Steps to Reproduce Problem

  1. In cells A1 and A2, enter the numbers 2 and 1 (in that order).

  2. Enter a note in any cell in the series and format the cell with a thick border style.

  3. Sort the data in ascending order.

  4. From the Formula menu, choose Note.

  5. The reference for the note will now refer to a row off the spreadsheet.

Reference(s):

"Microsoft Excel User's Guide," for the Macintosh, version 3.0, pages 234-242, 179-181

KBCategory: kbother
KBSubcategory:

Additional reference words: 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.