Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • OneDrive
      • Google Docs
      • Google Sheets
      • Google Drive
    • Email
      • Gmail
      • Outlook
      • Emal Etiquette
    • Office Etiquette
    • Productivity
    Inside The Web
    Home»Office»Excel»How to Open a Read-only Excel File

    How to Open a Read-only Excel File

    Nisha GurungBy Nisha GurungApril 13, 2023 Excel 4 Mins Read

    In Excel, even a tiniest change in the value can result in a formula error. So, if I have to view a shared sheet, we do recommend you to open them in read-only mode. This way, you can avoid making any accidental changes to the sheet as Excel won’t allow me to edit files. You could also do the same to be on the safe side.

    If you have a file that is already in the Read-Only mode, you can launch them like how you would normally do. Simply, click on the folder to open it.

    But, for workbooks with editing mode, there are a few steps you must undertake to launch them as read-only. You can either set a different Open file as option or run a VBA code.

    In this article, we have covered three proven methods to launch the file in Read-Only. Keep reading to learn about them!

    Set Workbook to Viewing Mode

    If you use the Microsoft Excel web version, you can simply switch your workbook from Editing to Viewing mode. To do so, next to the Comments icon, expand the drop-down menu for Editing and pick the Viewing option. Now, you won’t be able to make any changes to the workbook. 

    Open Workbook in Read-Only Mode

    For Excel app users, you cannot change your workbook’s viewing mode. However, while opening the file, you can choose to open it in Read-Only mode. 

    Here are the steps for it.

    1. Launch Excel.
    2. Select Open > Browse.
      Select Open- Browse
    3. On your PC, choose an Excel File.
      On your PC, choose an Excel File
    4. Expand the drop-down menu of Open and pick Open Read-Only. 
      Expand the drop-down menu of Open and pick Open Read-Only
    5. It will open the file in Read-Only mode.
      Open Workbook in Read-Only Mode

    Using Visual Basic

    Another method to open the Excel file in Read-Only mode is by using the Visual Basic tool. Although Visual Basics may sound intimidating, it isn’t quite as much as you think. Once you get how this works, I’m sure this powerful tool will help you master Excel.

    Here, we’ve created a code that will automatically launch the Excel file in Read-Only. For this, you just need to copy your Excel file path and replace it in the code. 

    If it’s your first time using Developer Tab, you need to actually add the tab from the Options menu. However, for users who’ve already added the tab, you may proceed with the given steps. 

    1. Launch Excel and create a New workbook.
    2. Go to Developer Tab > Visual Basic.
      go to Developer Tab-Visual Basic
    3. Below Microsoft Excel Objects, click on ThisWorkbook twice.
      Below Microsoft Excel Objects, click on ThisWorkbook twice
    4. Paste the given code in the empty space. On (Your Excel File Path) enter your file path like in the image.
      Sub Open_Workbook_As_Read_Only() 'Open a Workbook as Read-Only Workbooks.Open "(Your Excel File Path)", ReadOnly:=True End Sub
      Paste the given code in the empty space
    5. To insert the file path in the code, locate the Excel file you wish to open in Read-Only mode on your PC. Right-click on the file and pick Copy as Path. Then, paste it into the code.
      click on the file and pick Copy as Path
    6. Enter F5 to run the code.
    7. If prompted, click Run.
      If prompted, click Run
    8. Excel will launch the file in Read-Only mode.
      Excel will launch the file in Read-Only mode

    How to Prompt Excel to Open a Workbook as Read-only?

    By now, you must’ve figured out how to open the workbook in read-only mode. But, there are possible chances that you may forget and launch files in editing mode instead. 

    For this, you can actually force Excel to open the workbook as read-only. Meaning, whenever you click on a File, Excel will send a prompt box first to confirm the viewing mode of the workbook like in the given picture. Choose Yes to open in Read-Only. However, if you’re an author, you can also edit the files by picking the No option.

    Apart from setting this option for yourself, it will also come in handy when you’re sharing a workbook with others without password protection. But, note that except for authors no one can Edit Files. If needed, other users can Save the file as copy and modify the workbook.

    Save Workbook as Read-Only 

    1. Navigate to File Tab.
    2. Click on Save As > Browse.
      Click on Save As-Browse
    3. On the Save As window, expand the Tools menu > General Options.
      On the Save As window, expand the Tools menu -General Options
    4. On General Options, tick the box for Read-only recommended and click OK.
      On General Options, tick the box for Read-only recommended and click OK
    5. To confirm, click Save.

    Set Workbook to Always Open Read Only 

    1. On your worksheet, head to File Tab.
    2. Click on Info. Expand the Protect Workbook menu and pick Always Open Read Only.
      Expand the Protect Workbook menu and pick Always Open Read Only
    Excel Basics
    Nisha Gurung

      As a Business Student, Nisha first used Excel to outline data trends for her college projects. Later, she started exploring basic Excel functions when she realized it is a powerful tool for all businesses today. Nisha believes she can relate to many of the issues users face when starting their Excel Journey. She uses this knowledge and experience to curate contents that are fit for all types of Excel users. Apart from writing, she enjoys reading books and traveling.

      Related Posts

      Excel By Nisha Gurung

      How to Compare Two Columns in Excel Using VLOOKUP

      Excel By Nisha Gurung

      How to Share Excel Files with Multiple Users

      Excel By Nisha Gurung

      How to Filter Based on a List in Excel

      Add A Comment
      Table of ContentsToggle Table of ContentToggle
      • Set Workbook to Viewing Mode
      • Open Workbook in Read-Only Mode
      • Using Visual Basic
      • How to Prompt Excel to Open a Workbook as Read-only?
        • Save Workbook as Read-Only 
        • Set Workbook to Always Open Read Only 
      • Home
      • About Us
      • Privacy Policy
      © 2025 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.