Top Navigational Bar

Import Excel 3.0 File "Incompatible File Form
DocumentID: 653090
Revision Date: 29-Feb-96 8:29:20 PM

The information in this document applies to:
WordPerfect® 5.1 for DOS

Problem

Symptoms: When the customer imports an Excel 3.0 spreadsheet saved in a 2.1 format into WP, the error message "Incompatible File Format" appears when the customer chooses either Link or Import. The customer was able to save the file in Excel as a Lotus file (.WKS extension) and import it into WP without getting the error message. Solutions: This problem has been fixed in the 05/31/91 release although this change is not reflected in the 05/31/91 Software Change Notices. Excel uses a different number to designate the version in the file prefix of 3.0 files than it does in 2.0 or 2.1 files. When WP looked at the number that designated the version, the numbers didn't match, hence the error message.

In the 05/31/91 release, WP accepts either number for the version. This is an enhancement. WPCorp made the change to the WP program to accept Excel files that were created in 3.0 and saved in 2.1 format. WPCorp made the change to accommodate the change in Excel's file format, not because the WordPerfect software was working incorrectly.

Customers can convert Excel 3.0 for Windows spreadsheet files to 2.1 for WP 5.1 importation by following these steps:
1.      Enter Excel 3.0 for Windows and retrieve the file
2.      Pull down File
3.      Choose Save As
4.      Select Options
5.      Select Normal
6.      Select Excel 2.1 Format for Actual Conversion
7.      Exit without saving the file
8.      Use the normal WP spreadsheet importation process (Ctrl-F5, S, 1, etc.)

Answer:

Details:


Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER.