• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Excel: Force “Open as Read Only” Prompt

Excel: Force “Open as Read Only” Prompt

Posted on June 10, 2021 by Mitch Bartlett 2 Comments

If you have a file that is sensitive to changes, you can force Microsoft Excel 365 / 2019  to prompt the user to open as Read Only whenever they attempt to open the file. Here’s how to enable this setting.


Set Prompt While Saving File

Follow these steps to set the file to display the “Open as Read Only” prompt.

  1. In Excel, select “File” and click Save As.
    Excel save as
  2. Ensure the file format box is set to “Excel Workbook“, then select “More options…“.
    Excel 2016 More Options
  3. Choose “Tools” > “General Options” at the bottom of the window.
    Excel general options
  4. Select the check-box for “Read-only recommended“, then select “OK“.
    Excel read only recommended setting
  5. Select “Save“.
  6. If prompted, choose “Yes” to update the file with the read-only setting.

That’s it! Anybody who opens the file in Excel will now be prompted to choose “Open as Read-Only“.


Opening files as Read-Only

If the file has been saved using the above steps, you can directly open an Excel file as Read-Only using these steps:

  • Hold the “Shift” button and right-click the file. An option will appear to “Open as Read-Only“.

Excel Open as Read Only

 

You Might Also Like

  • Slack: How to Disable the Prompt to Confirm Marking Everything as Read
    Slack: How to Disable the Prompt to Confirm Marking…
  • Excel: This File Couldn't Open in Protected View
    Excel: This File Couldn't Open in Protected View
  • How Do I Force Restart Galaxy Tab S8
    How Do I Force Restart Galaxy Tab S8
  • MacOS: Force Quit Apps
    MacOS: Force Quit Apps
  • Why Do Android Apps "Force Close"?
    Why Do Android Apps "Force Close"?
  • Firefox for Android: How to Force Enable Zooming
    Firefox for Android: How to Force Enable Zooming
  • Can VPN be Tracked? Read This Before Buying One
    Can VPN be Tracked? Read This Before Buying One
  • How to Force Google Chrome to Always Show Full URLs
    How to Force Google Chrome to Always Show Full URLs
  • Linux Passwords: How To Force a User To Reset Their Password
    Linux Passwords: How To Force a User To Reset Their Password

Filed Under: Office Tagged With: Excel 2016, Excel 2019, Office 365

Reader Interactions

Comments

  1. Don says

    November 8, 2021 at 7:33 am

    can it be uncheck read only recommended using power shell?

  2. Tony Loyer says

    June 17, 2021 at 11:52 am

    Hey, I found your article very informative and interesting. We are having some issues with Excel at my work since we installed Office 365. My coworker and I used to be able to open files as read only if the other one was using it, but now we cannot do that. There are some files that we can’t open as read only even if the other one isn’t using it. We’ve tried saving them as read only, and using the option to shift and select read only and neither method is working. We thought it may be because the files were macro-enabled but it isn’t working with other kinds of excel files either. Do you have any insights into this matter that may help? Thanks for your assistance and have a wonderful day,

    Tony

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Windows 11: How to Add Clocks with Different Time Zones
  • Google Assistant: How to Never Miss a Birthday
  • Windows 11: How to Disable Notifications and Ads
  • How to Use Oculus Quest 2 Air Link
  • How to Create an Avatar in the Oculus Quest 2
  • 5 Free and Fun Math Apps for Kids
  • Windows 11: How to Discover What Graphics Card You’re Using
  • How to Change Display Resolution on Windows 10 and 11

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Open Standard
  • Open Source Software (OSS)

© Copyright 2022 Technipages · All Rights Reserved · Privacy