Daily Tech Dispatch

Microsoft Office

How to Make Excel Workbook Read Only (2026 Guide)

Learn how to make Excel workbooks read-only in 2026. Master structure locking, sheet protection, and OS-level settings. Get the complete guide here.

Did you just send a critical budget report and realize you forgot to lock it? If so, you aren’t alone. It happens to the best of us: you draft a file, share it with a client or colleague, and suddenly your carefully formatted pivot tables are being broken by a stray "Ctrl+Shift+End" or a deleted column.

The core question is simple: how to make Excel workbook read only? However, the answer is nuanced. "Read-only" can mean two different things in the Excel world: locking the file’s structure so no one can add or delete sheets, or applying sheet protection so specific cells remain locked while others stay editable. This guide covers both, plus the operating system-level settings for Windows and Mac, and the cloud-based methods for OneDrive and SharePoint.

I’ve spent the last 15 years dealing with messy spreadsheets, and I can tell you that knowing which type of lock to apply is just as important as knowing how to apply it. Let’s break it down by method, so you can pick the one that fits your threat model—whether that’s a helpful but careless coworker or a competitor trying to steal your IP.

Close-up of a rusty gate secured with three padlocks, symbolizing security and protection.

Method 1: Protect Excel Workbook Structure from Changes

Often, the biggest risk isn’t someone changing a number in a cell; it’s them deleting a reference sheet or hiding a hidden data tab. That’s where protect excel workbook from changes comes in. This feature locks the architecture of the file itself.

Locking Sheet Structure (No Password)

You don’t always need a password to stop people from deleting your sheets. Excel has a built-in structure protection that acts as a guardrail.

  1. Open your workbook.
  2. Go to the Review tab on the ribbon.
  3. Click on Protect Workbook (you might need to click the small arrow next to "Protect Sheet" to find it, or check under the Developer tab if you have it enabled).
  4. In the dialog box that appears, you’ll see two checkboxes: Structure and Windows.
    • Structure: Prevents adding, deleting, renaming, moving, or hiding sheets.
    • Windows: Prevents changing the size or position of the window, or creating new windows for the workbook.
  5. Check Structure. You can leave Windows unchecked unless you specifically want to freeze the window layout.
  6. Click OK.

In my experience, this is the most overlooked setting. Users assume that if they can edit cells, they have total control. They don’t. This stops the "oops, I deleted the master data tab" catastrophe. Note that this does not prevent cell editing. If you want to stop cell changes too, you need to look at Method 2.

Adding Password Protection for Stronger Security

If you are sharing this file with external parties or untrusted users, a password is essential.

In the same Protect Workbook dialog, type a password in the Password to unprotect structure field.

A word of caution: Excel’s built-in password protection for structure is not military-grade encryption. It’s a simple hash that can be reversed by anyone with enough time and basic VBA knowledge. I’ve seen colleagues break these in under five minutes using older versions of Excel or simple VBA scripts. Think of this as a "keep out" sign for honest users, not a vault for high-security data. If the data is truly sensitive, consider encrypting the file itself (File > Info > Protect Workbook > Encrypt with Password) instead of just the structure.

A minimalist image of a locked door casting a shadow in daylight.

Method 2: Make Specific Cells Read-Only via Sheet Protection

This is the most common use case: you want users to fill in a form (like a timesheet or expense report) but keep the formulas and layout intact. This is where you lock excel sheet password settings become vital, or where you use no password at all for a "soft" lock.

The 'Lock All, Unlock Selected' Technique

Here’s the counter-intuitive part: all cells in Excel are locked by default. But that lock is meaningless unless you turn on Sheet Protection. So, the workflow is a bit of a puzzle:

  1. Unlock the Input Cells:

    • Select the cells where you want users to type (e.g., the "Amount" column in an expense report).
    • Right-click > Format Cells > Protection tab.
    • Uncheck the "Locked" box.
    • Click OK.
    • Note: The cells you don’t select (the formulas, headers, etc.) remain "Locked" by default.
  2. Turn On Protection:

    • Go to the Review tab > Protect Sheet.
    • If you want a password, enter it here. If not, leave it blank.
    • You’ll see a list of allowed actions. By default, only "Select unlocked cells" is checked. This means users can click on the input fields but can’t delete rows, insert columns, or format anything.

The result? Users can type into your designated "unlocked" cells, but the rest of the sheet acts as a rigid, read-only canvas. I always tell my teams: "If you want them to type, unlock the target. If you want to stop them, lock the source."

Allowing Data Entry While Keeping Layout Locked

You might want to allow users to sort or filter data while keeping the rest locked. This addresses the long-tail query: lock excel sheet but allow data entry (and more).

In the Protect Sheet dialog, look at the list of permissions. You can check boxes for:

  • Sort
  • Insert Rows
  • Filter
  • Use PivotTable Reports

For example, in a data entry form, I often allow "Insert Rows" so users can add new expenses, but I keep "Delete Columns" unchecked so they can’t break the structure. It’s a fine balance. Too much permission, and you lose control. Too little, and your users will hate you for making the tool useless.

Method 3: Windows & Mac File Attributes (Quick Fix)

Sometimes, you don’t want to mess with Excel’s internal settings. You just want the operating system to treat the file as unchangeable. This is where excel read only mode settings live at the OS level.

Windows: Setting Read-Only Attribute via File Explorer

This is the quickest fix, but also the least secure.

  1. Close the Excel file.
  2. Navigate to the file in File Explorer.
  3. Right-click the file > Properties.
  4. At the bottom of the General tab, check the Read-only box.
  5. Click Apply > OK.

What this does: It prevents accidental overwrites. If you try to save changes in Excel, it will prompt you to save as a new file. What it doesn’t do: It’s trivial to bypass. Anyone can right-click the file, uncheck "Read-only," and edit it. I use this for files I’m currently working on but don’t want to accidentally clobber with a version control sync. It’s not security; it’s a safety net.

Pro Tip: You can also set this default inside Excel. Go to File > Options > Advanced. Under "Edit a file when it opens," select Always Open Read-Only. This forces Excel to ask for permission before every save, which is great for protecting master files on your desktop.

Mac: Read-Only Status and Save As Options

Mac users have a slightly different interface.

  1. Open the workbook in Excel for Mac.
  2. Go to the File menu > Set or Clear Read-Only Status.
  3. To enforce it, go to File > Save As. In the save dialog, look for the File Format or Options section (this can vary slightly by macOS version). You can often set the file to "Read-only recommended" here.

On Mac, you’ll notice a small icon in the title bar if the file is read-only. It’s a subtle lock symbol. If you see "Read only window title bar" indicators, that’s your confirmation the attribute is active. Like Windows, this is a soft lock. Users with write permissions to the folder can clear it. For shared network drives on Mac, you often have to manage this at the server permission level rather than the individual file level.

Advanced: Sharing Read-Only Links on OneDrive & SharePoint

If you’re working in the cloud, local file attributes don’t matter. The file lives on a server, and share excel file as read only link is the correct approach. Many users get stuck here because they think local file locking works in the cloud. It doesn’t.

Configuring 'Can View' vs 'Can Edit' Permissions

When you click Share in Excel (cloud version), you’re not just sending a file; you’re assigning permissions.

  1. Click the Share button in the top right.
  2. You’ll see options for who can access the link: Anyone with the link, Specific people, or People in your organization.
  3. The critical setting is the toggle at the bottom: Can view or Can edit.

Select Can view. This creates a link that opens in Excel Online or the app, but the "Edit" button is grayed out. Users can see the data, they can filter (if you allow it via other settings), but they cannot type over your cells.

Permissions management is key here. You can go into the People with access pane (click "Manage access" or the "..." icon) to revoke access from specific users or change their level from "Edit" to "View" later. I recommend restricting sharing to "Specific people" for sensitive workbooks. "Anyone with the link" is a security leak waiting to happen.

Troubleshooting: 'Why Can They Still Edit My Shared File?'

This is a classic support ticket. The user sets the link to "Can View," but the recipient opens it and types in a cell. Why?

The usual suspect: The recipient is signed into a different account or has "Edit" permission through a different pathway.

  • Scenario A: You shared the link as "Can View," but you also added the person to a shared folder in SharePoint where they have "Edit" rights on the whole library. The library permission overrides the link permission.
  • Scenario B: The user is working in desktop Excel, and the file is syncing to OneDrive. If the OneDrive client has write access to the file locally, they can edit it locally, and the sync will push the changes back up, effectively bypassing the "View" link restriction.

The Fix:

  1. Check SharePoint/OneDrive admin settings to ensure no group permissions are granting "Edit" rights.
  2. Tell the user to use Excel Online (in the browser) for strict read-only viewing, rather than desktop Excel on a synced folder.
  3. If you need to prevent local sync editing, you must set the file to read-only at the server level (SharePoint content permissions) or rely on Version History to roll back bad changes.

VBA Automation: Force Excel to Open in Read-Only Mode

For developers and power users, there’s a programmatic way to handle this. If you’re building a reporting script, you can force Excel to open the output file in read-only mode. This is useful for excel vba to open read only workflows.

Simple VBA Snippet for Developers

Here’s a copy-paste snippet. Open the VBA editor (Alt + F11), insert a Module, and paste this:

Sub SaveAndOpenReadOnly()
    Dim wb As Workbook
    Dim filePath As String
    
    ' Define the file path
    filePath = "C:\Reports\MyReport_" & Format(Now, "yyyy-mm-dd") & ".xlsx"
    
    ' Save the workbook as read-only
    ActiveWorkbook.SaveCopyAs FilePath:=filePath
    ActiveWorkbook.SaveAs2 Filename:=filePath, FileFormat:=xlOpenXMLWorkbook, _
                           Password:="1234", WriteResPassword:=""
    
    ' Open the saved copy in read-only mode
    Set wb = Workbooks.Open(Filename:=filePath, ReadOnly:=True)
    
    ' Optional: Display a message
    MsgBox "File saved and opened in Read-Only mode.", vbInformation
End Sub

Key points:

  • SaveAs2 with a Password parameter creates a file that requires a password to save.
  • Workbooks.Open with ReadOnly:=True forces the file to open in view-only mode.
  • Warning: If the user has access to the VBA code, they can delete this line. Combine this with Workbook Structure Protection (Method 1) to make it harder to bypass. This is macro security 101: never rely on one layer of defense.

FAQ

How do I make an Excel file read only without a password?

You have two main options. First, use File > Info > Protect Workbook and check "Structure" without entering a password. This stops people from deleting sheets but allows them to edit cells. Second, use Windows File Properties to check the "Read-only" attribute. This prevents saving changes to the original file, but users can easily uncheck it. For most business needs, the Structure Protection without a password is the safer "set it and forget it" option for internal teams.

What is the difference between protected view and read-only?

This is a very common point of confusion. Protected View is a security sandbox. When you open a file from the internet or an email, Excel opens it in Protected View to prevent malicious macros from running. You see a yellow bar at the top saying "Protected View" with an Enable Editing button. It’s temporary; you click the button, and you’re in normal edit mode.

Read-Only, on the other hand, is a persistent state. The file is designed to be viewed, not edited. There is no "Enable Editing" button unless you have the password. If you try to save, you’re prompted to save a new copy. Protected View is about security against malware; Read-Only is about workflow control.

Why is my Excel file stuck in read-only mode?

Usually, it’s one of three things:

  1. The file is open in another process: You have two instances of Excel open, or a sync client (OneDrive/Box) is holding the file lock. Close all Excel instances and retry.
  2. Windows Permission Denied: You don’t have write access to the folder where the file is saved. Check your folder permissions in File Explorer.
  3. Network Path Issues: If the file is on a mapped drive, the drive may have disconnected. Ping the server or reconnect the network drive.

Can I make only specific cells read-only in Excel?

Yes, and it’s the standard way to build input forms. You need to uncheck the "Locked" box for the cells you want to be editable (via Format Cells > Protection). Then, go to Review > Protect Sheet. Once the sheet is protected, only the unlocked cells will accept data. The rest of the sheet becomes read-only. This is the "Lock All, Unlock Selected" technique described in Method 2.

Conclusion

We’ve covered the three main levels of protection: File Attributes (OS-level), Sheet/Structure Protection (Excel-internal), and Cloud Permissions (OneDrive/SharePoint).

Remember: "Read-Only Recommended" is just a suggestion. It’s the digital equivalent of a "Please Do Not Touch" sign on a museum exhibit. Anyone with the will can move it. For real security, layer your defenses. Use Structure Protection to stop sheet deletion, use Sheet Protection to control cell input, and use Cloud Permissions to control who sees the file at all.

Before you send that critical workbook, I always do one thing: I send it to a trusted colleague and ask them to try and break it. They’ll delete a column, hide a sheet, or overwrite a formula within minutes. Once they can’t, you’re ready to ship.

If you want to ensure you’ve locked all vectors, I’d recommend downloading our 'Excel Protection Checklist' PDF. And if you’re the owner and need to get back in? Check our guide on How to Remove Passwords from Excel (ethically, of course).

Back to Home