Sharing Quattro Pro spreadsheets with Microsoft Excel users
Quattro Pro makes it possible for you to share your Quattro Pro spreadsheets with Microsoft Excel users and for them to share their workbooks with you.
For example, to share a Quattro Pro spreadsheet with a Microsoft Excel user, you must save the Quattro Pro spreadsheet as a Microsoft Excel file. The saving process automatically converts the spreadsheet to the Microsoft Excel format.
In addition, if you receive a file created in Microsoft Excel, all you need to do is open it in Quattro Pro. The opening process automatically converts the file to the Quattro Pro format. If you modify the same file and you want others to view the changes in Microsoft Excel, then you need to save the file as a Microsoft Excel file. You can, however, specify that the default format when saving files is set to the Microsoft Excel file format. If you don’t specify the Microsoft Excel format when saving, the file is saved as a Quattro Pro file by default.
Microsoft Excel workbooks that contain custom spreadsheet names may not open in Quattro Pro if characters used in the names are not recognized by Quattro Pro. If this happens, Quattro Pro displays a dialog box warning you about the invalid spreadsheet name. You can change the spreadsheet name to make it compatible with Quattro Pro.
For a list of conversion considerations, see “Reference: Moving between Microsoft Excel and Quattro Pro.”
To save a Quattro Pro notebook as a Microsoft Excel file |  |
|
1.
|
|
Click File
 Save as. |
|
2.
|
|
Choose the drive and folder where you want to save the file.
|
|
3.
|
|
Type a filename in the Filename box.
|
|
4.
|
|
Choose a Microsoft Excel file type from the File type list box.
|
To open a Microsoft Excel workbook in Quattro Pro | |
|
1.
|
|
Click File
Open. |
|
2.
|
|
Choose the drive and folder where the workbook is stored.
|
|
If you can’t see the file, choose All files from the File type box.
|
|
3.
|
|
Double-click the workbook’s filename.
|
|
•
|
|
When opening Microsoft workbooks in Quattro Pro, some information may not display as it did in Microsoft Excel.
|
To automatically save files opened in Quattro Pro to the Microsoft Excel format | |
|
1.
|
|
Click Tools
Settings. |
|
2.
|
|
In the list of categories, double-click Compatibility.
|
|
3.
|
|
Choose XLS from the Default file type list box.
|
To fix invalid spreadsheet names | |
|
1.
|
|
Open a Microsoft Excel file in Quattro Pro.
|
|
In the Quattro Pro dialog box, the invalid spreadsheet name displays in the Invalid name box.
|
|
2.
|
|
Enable one of the following options in the Rename options area:
|
|
•
|
Fix invalid spreadsheet name — changes the spreadsheet name to include only valid Quattro Pro characters. The new name displays in the New name box.
|
|
•
|
Do not fix invalid spreadsheet name — keeps the original spreadsheet name
|
|
If you want to make additional changes to the name, type them in the New name box, using valid Quattro Pro characters.
|
|
•
|
|
If you enable the Do not fix invalid spreadsheet name option and try to use the Microsoft Excel spreadsheet name, you cannot initiate formulas and macros.
|
|
•
|
|
If you enable the Fix invalid spreadsheet name option but have used the original spreadsheet name in cell references, you must search for these references and replace them with the new name.
|