Excel .XLS Export Options Dialog

 

The Excel Data Export Options dialog allows you to specify if the Excel file will be written in Excel 97 or Excel 95 format.

 

Excel Data Export Options Dialog

Select a data module and choose the File | Save Data command to open the Excel Data Export Options dialog.

Excel Data Export Options
Select the
File Format to use when exporting in
the
XLS Import Options dialog.

 

File Format

Files can be saved in either Excel-97 (BIFF8) or Excel-95 (BIFF5) formats.

 

OK

Click the OK button to save your changes and export the file.

 

Cancel

Click the Cancel button to exit the dialog without saving your changes or exporting the file.

 

Use Caution when Saving Excel Files!

A file can be saved in an Excel format, but only one worksheet can be saved. The Excel export filter does not allow for saving multiple worksheets in a single Excel document. If a multi-worksheet Excel file is opened and saved as an .XLS file, be aware that only the single worksheet is saved in the document. If the existing file is overwritten, all the unused worksheets are destroyed. In this case, a warning message is issued. The message reads: Saving this worksheet will destroy all but one of the sheets in the existing *.xls file. To overwrite the file, click the OK button. To choose a different file name, click the Cancel button.

 

 

See Also

Excel Import Options Dialog

Excel File Description

File Format Chart