XL97: File with Many Cell Notes Opens Slowly

• Microsoft Excel 97 for Windows

SYMPTOMS

When you open a file, Microsoft Excel 97 may take a long time to open the file. Also, after you open the file in Microsoft Excel and save it, the file may increase significantly in size.

CAUSE

This problem may occur when the following conditions are met:

• You open a file that was created Microsoft Excel version 5.0 or 7.0.

  -and-

• The file contains a large number of cell notes.

WORKAROUND

If the cell notes are not needed, you can work around this problem by reopening the file in Microsoft Excel 5.0 or 7.0, and clearing all the notes in the workbook. The file should then open significantly faster in Microsoft Excel 97.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Like cell notes, comments are attached to worksheet cells. You can view each comment when you move the pointer over the cell, or you can view all of the comments at the same time. You can print comments in the same locations in which they appear on the worksheet, or you can print comments in a list at the end of the worksheet. Also, Microsoft Excel adds your user name to the top of each cell note that you insert on your worksheet.

REFERENCES

For more information about Cell Comments, click the Index tab in Microsoft Excel Help, type the following text

   comments