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.
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