Microsoft KB Archive/96315

= Microsoft Knowledge Base =

Sheet with Multiple Hidden Rows & Double Borders Opens Slowly
Last reviewed: September 12, 1996

Article ID: Q96315

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0

SYMPTOMS
In Microsoft Excel, a worksheet that contains multiple hidden rows and has more than one cell formatted with a double-line border may take several minutes to open. Because it takes so long for this worksheet to open, it may appear that your computer is not responding (is hung); however, the worksheet will eventually open.

WORKAROUND
To work around this problem, do the following to change the double line borders to single lines:


 * 1) Select the cells that are formatted with double line-borders.
 * 2) From the Format menu, choose Cells, and then select the Border tab. (Choose Border from the Format menu in versions 4.0 and earlier).
 * 3) Under Border, select the Bottom option and under Style, select one of the single underline border options.
 * 4) Choose the OK button.
 * 5) From the File menu choose Save and close the file.

When you open the file again, it should open in a normal amount of time.

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. We are researching this problem, and will post more information here in the Microsoft Knowledge Base as it becomes available.