← Back to blog

Is My Excel File Encrypted or Protected? How to Tell the Difference

Telling encryption from protection in Excel prevents confusion and saves time. Here are concrete indicators for each case and what to do next.

Signs the file is encrypted

  • On open, Excel prompts for a password to view the content.
  • Without the correct password, you cannot see any data.
  • Modern versions use AES‑256 encryption (strong and not “removable”).

What to do:

  1. Check your password manager and internal documentation.
  2. Contact the owner or IT if applicable.
  3. Avoid tools that claim to “crack” encryption—often unreliable or risky.

Signs it’s sheet or workbook protection

  • The file opens, but you cannot edit cells, change formats, or move sheets.
  • The “Review → Unprotect sheet/workbook” command is available.
  • Some cells are locked or the workbook structure is rigid.

What to do:

  1. If authorized, remove protection using the known password.
  2. If you don’t remember it, use a specialized tool to remove editing protection, such as KeylessFile.
  3. Validate formulas and formats after removal.

Quick checks (Windows and macOS)

  • Visual check: Review tab → Unprotect Sheet/Workbook. If present, it’s usually protection, not encryption.
  • Prompt semantics: “Enter password to open” = encryption; “The sheet is protected” = editing protection.
  • File → Info: review the Protect Workbook section and shown options.

Optional technical check (diagnostics only):

  • Make a copy, rename .xlsx to .zip, and open it.
    • If you see readable XML under xl/worksheets/, it’s likely not full‑file encryption.
    • If contents are not readable and structure differs, it may be encrypted.
      Note: diagnostic only, not an access method.

Additional checks

  • Hidden sheets: check for hidden or “very hidden” sheets.
  • External links: may leak context; consider breaking or updating before sharing.
  • Metadata: run “Info → Inspect document” to clean properties and hidden content.

General rule of thumb

  • Strong confidentiality needed → Encryption (password to open).
  • Editing control and usability → Sheet/workbook protection.

For safe removal of editing restrictions, see /en/how-to-unprotect-excel or the main tool on the homepage.

Common scenarios and resolution

  • “I can open the file but cannot edit key cells”: sheet protection. Use Review → Unprotect Sheet or authorized tools.
  • “On open, I’m prompted and cannot see any content without a password”: encryption. Check your manager or contact the owner.
  • “Sheets disappear when sharing”: review protected structure and hidden/very hidden sheets.