XL: Functions Not Saved to Quattro Pro File Format

ID: Q111981

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for Windows 95, version 7.0
Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel, when you save a worksheet in the QuattroPro/DOS (.wq1) file format, you may receive one of the following error messages.

In Microsoft Excel versions 5.0 and 7.0

Cannot write record. (Cell: <cell ref>)

Where <cell ref> is a worksheet cell reference.

In Microsoft Excel 97


   A formula in cell (Cell: <cell ref>) could not be converted
   because it contains a function that is not available in the
   format to which you are saving. If you continue the save, the
   formula and result will be saved, but the function itself will
   be converted to an error value.

   Do you want to see additional errors as they occur so you can
   fix them later?

When you open the file you saved in the QuattroPro/DOS format, the cell that contained a formula now contains just the value as it appeared when the workbook was saved.

CAUSE

When saving to the QuattroPro/DOS (*.wq1) format, you will receive the error message if your workbook contains any of the following Microsoft Excel worksheet functions:


   - N()
   - T()
   - NPER()
   - FV() - only if you use the optional arguments pv and type
   - PMT() - only if you use the optional arguments fv and type
   - PV() - only if you use the optional arguments fv and type

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article.

MORE INFORMATION

Quattro Pro is manufactured by Borland, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

REFERENCES

Excel 97

For more information about formatting and features not saved in Quattro Pro file conversions, click Contents And Index on the Help menu, click the Index tab in Excel Help, type the following text

Quattro Pro, converting files

and then double-click the selected text to go to the "Formatting and features not transferred in file conversions" topic. Within the topic select Quattro Pro. If you are unable to find the information you need, ask the Office Assistant.

Excel 5.0

For more information about Opening Quattro Pro for MS-DOS files in Microsoft Excel, click the Search button in Help and type:

Quattro Pro

Additional query words: 5.00c 8.00 97

Keywords : xlloadsave xl123Quattro
Version : WINDOWS:97,7.0,5.0,5.0c
Platform : WINDOWS
Issue type :