Here's our Microsoft Office Tip for.. January 4, 1999
Click Here to see a complete list of all of our previously released Tips!
Save Excel Worksheets in Different File Formats
There may be times when you need to share information with others, perhaps a co-worker, and that person might not be using the same spreadsheet application as you. For example, if you need to create a worksheet that will be used in Lotus 1-2-3, you can choose File, Save As to tell Excel what you want to do. When the Save As dialog box opens, click on the down arrow at the right side of the Save as Type list box to expand the list. From the list choose the version of Lotus that will use the file. If you're not sure of the Lotus version, select the one labeled (All). Now type in a name and save the file. You'll be warned that you're saving in a non-Excel format. Go ahead with the save.
When you try to close the worksheet, you'll receive another warning about saving the file in a non-Excel format. Just click on OK through these dialog boxes.
Note: Many of the Excel features that you used may be lost in the saved document. Before you save to a different file type, always save your file in the standard Excel format first. Also, you shouldn't even attempt to do this with a worksheet that contains any Excel macros.