Microsoft KB Archive/175541

From BetaArchive Wiki
Knowledge Base


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:

    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:

  1. Open the protected workbook in Microsoft Excel.
  2. On Tools menu, point to Protection, and then click Unprotect Workbook.
  3. On the File menu, click Save As, type a new name for the workbook, and then click Save.
  4. 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