Formatting and Charts Not Saved to .WQ1 Format (110708)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q110708 SUMMARY
In Microsoft Excel, the formatting and any chart sheets contained in the
file may be lost when you save the file in the Quattro Pro for DOS (.WQ1)
file format (a format used by Corel Corporation's Quattro Pro
spreadsheet application).
WORKAROUND
To ensure that most of the formatting is retained when you export a file to
Quattro Pro, save the file in the WK1,FMT (1-2-3) (.WK1) file format. The
WK1/FMT (1-2-3) file format can handle more formatting information than the
.WQ1 file format. The latest versions of Quattro Pro can read the WK1/FMT
format.
To save a file in the WK1/FMT file format: - Activate the sheet that you want to save. (Activating this sheet is
necessary because only the active sheet will be saved.)
- From the File menu, choose Save As.
- In the File Name box, enter the new name of the file. For example,
"TEST". It is not necessary to include an extension at the end of the
file name.
- From the Save File As Type box, select WK1/FMT (1-2-3).
- Choose OK to save the file.
- Choose OK when you receive the message "Selected file type will save
only the active sheet."
The file is saved in the WK1/FMT file format.
Note that when you use the above workaround, any chart sheets contained in
the file are not saved, as indicated in the message above.
Modification Type: | Minor | Last Reviewed: | 8/15/2003 |
---|
Keywords: | KB110708 |
---|
|