Article ID: 175541
Article Last Modified on 1/22/2007
APPLIES TO
- Microsoft Works 4.5 Standard Edition
- Microsoft Works 4.5a
- Microsoft Works 4.0 Standard Edition
- Microsoft Works 2000 Standard Edition
- 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:
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.
Additional query words: 4.00a 4.50 4.50a w_works works2000 wks encryption encrypted
Keywords: kbfaq kbprb KB175541