comments moving randonmly after a save & close
 

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!

comments moving randonmly after a save & close
 

Are the cells containing the comments included in your sort?


"Tam" wrote in message
...
| 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!

comments moving randonmly after a save & close
 

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.

"Rob Giordano (Crash)" wrote:

Are the cells containing the comments included in your sort?


"Tam" wrote in message
...
| 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!