comments moving randonmly after a save & close

T

Tam

Spreadsheet contains lots of comments with just typed in notes, (no formulas
or macros in them). After sorting, saving & closing the file when you open it
again some of the comments have moved to a different cell & original comment
is lost. Using Excel 2002. HELP!
 
R

Rob Giordano \(Crash\)

Are the cells containing the comments included in your sort?


| Spreadsheet contains lots of comments with just typed in notes, (no
formulas
| or macros in them). After sorting, saving & closing the file when you open
it
| again some of the comments have moved to a different cell & original
comment
| is lost. Using Excel 2002. HELP!
 
M

Mary

Yes - the file is sorted by entire rows. Comments are okay after the sort.
The problem shows up after the file is closed and reopened.
 
Top