Hi. Can anyone suggest a solution for this issue:
SYSTEM: Windows XP--Running Office Professional
PROBLEM: Excel 2000 .xls file comments are lost when Excel 2003 reads file.
.xls file saved in Excel 2000 (9.0.4402 SR-1) contains comments.
When this file is read by Excel 2003 (11.5612.5606), Excel 2003 displays message, “File error: data may have been lost.” The old-version .xls file then displays with its comments lost/dropped.
We've saved the Excel 2000 file as: (1) "Microsoft Excel Workbook (*.xls)"; (2) Microsoft Excel 5.0/95 Workbook (*.xls)"; and (3) Microsoft Excel 97-2000 & 5.0/95 Workbook (*.xls)."
In each instance, Excel 2003 drops cell comment boxes.
* * *
Many thanks for prompt replies.