Works: How to Import Data from Excel Workbook with More Than One Worksheet

Article translations Article translations
Article ID: 253405 - View products that this article applies to.
This article was previously published under Q253405
Expand all | Collapse all

SUMMARY

This article describes how to import data from a Microsoft Excel 2000 workbook into Microsoft Works if the Excel 2000 workbook contains more than one worksheet.

Because you can only import one worksheet from an Excel 2000 workbook into a Works Spreadsheet file, you need to create a new Works Spreadsheet file for each worksheet in the Excel 2000 workbook.

MORE INFORMATION

To import data from an Excel 2000 workbook that contains more than one worksheet into Works:

  1. On the Works Task Launcher, click the Programs tab.
  2. Click Works Spreadsheet, and then click Start a blank Spreadsheet.
  3. On the File menu, click Open.
  4. In the Files of type box, click Excel SS (*.xl*).
  5. Browse to the Excel 2000 workbook that you want to import into Works, click the workbook, and then click Open.
  6. In the Import Excel Spreadsheet dialog box, click the worksheet that you want to import into Works, and then click OK.
  7. On the File menu, click Save.
  8. In the File name box, type a name for the worksheet, and then click Save.

    The worksheet is saved as a Works Spreadsheet file.
Repeat these steps to import each worksheet from the Excel 2000 workbook into Works as a Works Spreadsheet file.

Properties

Article ID: 253405 - Last Review: January 27, 2007 - Revision: 3.1
APPLIES TO
  • Microsoft Works 2000 Standard Edition
  • Microsoft Works 6.0
  • Microsoft Works Suite 2000
  • Microsoft Works Suite 2001
Keywords: 
kbhowto kbinterop kbui KB253405
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com