Works 2000: No Worksheets Listed When You Try to Open Excel Worksheet

When you are using the Microsoft Works 2000 Spreadsheet and you attempt to open a Microsoft Excel worksheet, there are no worksheets listed in the Import Excel Spreadsheet dialog box, and only the Cancel button is available.

There is no message explaining why no worksheets are listed.

This behavior can occur when the Excel workbook you are trying to open in Works 2000 is password-protected.

NOTE: If only individual worksheets have password protection, the worksheets are listed and the following message appears when you attempt to open a protected worksheet:

To work around this issue, remove the password protection from the Excel workbook. To remove password protection, follow these steps:

1. Start Microsoft Excel.
2. On the File menu, click Open.
3. Browse to find the file that you want, and then click Open.
4. On the Tools menu, point to Protection, and then click Unprotect Workbook.
5. Enter the password, and then click OK.
   
   NOTE: If you want to password-protect an individual worksheet, follow these steps:
   
   
   1. Select the worksheet you want to protect.
   2. On the Tools menu, point to Protection, and then click Protect Sheet.
   3. Enter the password you want, and then click OK.
   4. Confirm the password, and then click Ok.
6. On the File menu, click Save, and then close Excel.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.