Microsoft KB Archive/111981

= Functions Not Saved to Quattro Pro File Format =

Article ID: 111981

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q111981



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: )

Where is a worksheet cell reference.

In Microsoft Excel 97
  A formula in cell (Cell: ) 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.



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 XL

Keywords: KB111981

-

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

© Microsoft Corporation. All rights reserved.