Works: Excel Files Not Listed in Import Excel SS Dialog Box (175541)

The information in this article applies to:

Microsoft Works 4.5
Microsoft Works 4.5a
Microsoft Works for Windows 95, version 4.0
Microsoft Works 2000
Microsoft Works Suite 2000

This article was previously published under Q175541

SYMPTOMS

When you try to open a Microsoft Excel file in Microsoft Works, you may experience one of the following symptoms:

You see a dialog box titled Import Excel Spreadsheet, but no sheets are listed.
When you click a sheet, and then click OK, you may receive the following error message:
This document is password-protected or encrypted. Open it in the application that saved it, remove the password or encryption, then save it again. Then try to open it again in Works.

CAUSE

The Microsoft Excel workbook you are trying to import has been password protected.

RESOLUTION

Open the workbook in Microsoft Excel and remove the password protection.

To remove the password protection, follow these steps:

Open the protected workbook in Microsoft Excel.
On Tools menu, point to Protection, and then click Unprotect Workbook.
On the File menu, click Save As, type a new name for the workbook, and then click Save.
Open Works and import the newly created Excel spreadsheet.

MORE INFORMATION

If you open an Microsoft Excel 5.0 or 7.0 file with password-protected sheets, all of the sheet names are visible in Works in the Import Excel Spreadsheet box. However, if you select a sheet that is password protected, you receive the following message:

This document is password-protected or encrypted.

Works spreadsheet files do not support multiple sheets. When you try to open a Microsoft Excel file with multiple sheets, Works will open each sheet as a separate file.

Modification Type:	Minor	Last Reviewed:	1/24/2005
Keywords:	kbprb KB175541