Microsoft KB Archive/80227

{| = Excel: Cell Note Reference Gets Corrupted After Sort =
 * width="100%"|

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): &quot;Microsoft Excel User's Guide,&quot; for the Macintosh, version 3.0, pages 234-242, 179-181
 * }