XL: Functions Not Saved to Quattro Pro File Format

• 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 receive one of the following error messages:

In Microsoft Excel versions 5.0 and 7.0

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

In Microsoft Excel version 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?

CAUSE

When saving to the QuattroPro/DOS (*.wq1) format, you will receive one of the stated error messages 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. We are researching this problem, and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

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

   Quattro Pro