XL98: Read-Only Recommended Opening 97/98 & 5.0/95 Workbook File Format (181668)

CAUSE

This behavior occurs when all of the following conditions are true:

You save the file by clicking "Microsoft Excel 97/98 & 5.0/95 Workbook" in the Save As list in the Save As dialog box in Microsoft Excel 98. -and-
You open the file in Microsoft Excel version 5.0 and click No when you are prompted to open the file as read-only. -and-
You then save the file from Microsoft Excel 5.0 with the same name.

NOTE: When you do this, the Microsoft Excel 98 portion of the file format no longer exists.

MORE INFORMATION

In Microsoft Excel 98, you can use a new hybrid file format that allows you to save a file in both the Microsoft Excel 98 workbook format and the Microsoft Excel 5.0 workbook format. This dual file format allows you to open and view the file in Microsoft Excel 5.0 and maintain the advanced features in Microsoft Excel 98.

A workbook that you save in this dual format contains two file formats; the file size is roughly twice as large as the Microsoft Excel 98 format. However, Microsoft Excel 5.0 does not recognize the Microsoft Excel 98 portion of the file. When you open and revise the file in Microsoft Excel 98, changes are also automatically updated in the Microsoft Excel 5.0 portion of the file.

NOTE: If you edit the file and save the changes in Microsoft Excel 5.0, the Microsoft Excel 98 portion of the file is permanently lost, and the file contains only the data in the remaining Microsoft Excel 5.0 workbook file portion.

The Read-Only Recommended option is selected for the Microsoft Excel 5.0 portion of the file. However, you can open and save the file in Microsoft Excel 5.0. Because Read-Only Recommended is selected by default for the "Microsoft Excel 5.0/95 Workbook" format, the workbook file that you save also uses the Read-Only Recommended option.

Disabling the Read-Only Recommended Prompt and Resaving the File in the "Microsoft Excel 97/98 & 5.0/95 Workbook" Format

To disable the prompt and resave the file, follow these steps:

On the File menu, click Open, click the workbook file name, and then click Open to open the file in Microsoft Excel 98.
When you are prompted to open the file as read-only, click No.
On the File menu, click Save As and click "Microsoft Excel 97/98 & 5.0/95 Workbook" in the Save As Type list.
Click Options in the Save As dialog box.
Clear the Read-Only Recommended check box. Then, click OK, and click Save.

For additional information, please see the following articles in the Microsoft Knowledge Base:

157497 XL: Saving a File for 5.0/7.0 and MS Excel 97 or MS Excel 98

REFERENCES

For more information about the Microsoft Excel 97/98 & 5.0/95 file format, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

file formats, Microsoft Excel

and then click Show Topics. Select the "Using Microsoft Excel 98 with previous versions of Microsoft Excel or other programs" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.