File Saved in XL4 from Lotus 1-2-3 Does Not Display Gridlines (131550)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0
This article was previously published under Q131550

SYMPTOMS

In Lotus 1-2-3 version 5.0, you can save a file as a Microsoft Excel 4.0 worksheet or workbook. When one of these files is opened in a version of Microsoft Excel listed at the beginning of this article, the gridlines may not be displayed. This problem will occur even though the gridlines are turned on in the View tab of the Options dialog box in Microsoft Excel.

CAUSE

The gridlines are not displayed because the pattern of the Normal Style is set to the color white.

RESOLUTION

To display the gridlines, you can use the following steps:

  1. On the Format menu, click Style.
  2. In the Style dialog box, in the Style Name box, select or type Normal.
  3. Click Modify, and then click the Patterns tab.
  4. Under Color, select No Color (in version 97) or None (in versions 5.0 and 7.0).
  5. Click OK twice to return to the worksheet.
If the Color in Step 4 is already set to No Color or to None, follow these steps:

  1. Under Color, select any color except for No Color or for None.
  2. Click OK twice to close the Style dialog box.
  3. Repeat steps 1-5 above.

MORE INFORMATION

Lotus 1-2-3 is manufactured by Lotus Corp., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this products' performance or reliability.
Modification Type:MinorLast Reviewed:8/15/2005
Keywords:kbconversion kbprb KB131550
©2004 Microsoft Corporation. All rights reserved.