Microsoft KB Archive/131550

= File Saved in XL4 from Lotus 1-2-3 Does Not Display Gridlines =

Article ID: 131550

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



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.

Additional query words: 5.00c 8.00 97 XL

Keywords: kbconversion kbprb KB131550

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.