This Workbook Was Opened in Read Only Mode

Whether y'all desire other people to edit your excel workbook without permission? If not, then setting your excel workbook read only is a common only good method for yous to choose.

If yous accept no thought about how to set up excel workbook read merely, post-obit article would tell you several ways that you can utilize to restrict other people from changing your workbook. (Eg. Excel 2010)

• Way one: Set Excel Workbook read only by "Marker as Final" choice
• Fashion two: Marker Excel Workbook "Read-only recommended"
• Way 3: Gear up modify countersign to protect Workbook in read only manner
• Way 4: Protect Workbook structure to prevent unwanted changes
• Way 5: Protect sheets in Workbook to keep read but

Way 1: Set Excel Workbook Read Only by "Mark as Last"

ane. Navigate to File > Info, click Protect Workbook and select Mark every bit Concluding in several options that you tin can use to protect your workbook.

ii. Click "OK" on pop-up dialog to brand sure this workbook volition be marked as final and saved.

Then a bulletin would prompt you that the settings would plough off typing, editing commands and proofing marks. But really the selection "Marking as Final" would just brand readers know the workbook is read-but. If you want to remove it, you just need to select "Mark as Final" selection in File > Info > Protect Workbook once more.

So fifty-fifty though it could assist to set excel workbook read only, it still cannot prevent people from editing.

Fashion 2: Mark Excel Workbook "Read-only recommended"

i. Click File > Salvage Every bit in Excel, and so in Save As dialog, select Tools > Full general Options.

ii. Cheque "Read-only recommended" in following General Options dialog. And click OK.

3. Tap on "Save" push and save excel workbook to replace that already exists.

From then on, when other people open the excel workbook, they volition exist prompted that the excel workbook should be opened every bit read-simply unless they demand to salvage changes to it. But they withal have choices to open workbook as read simply or not.

Choice ane:

Select "Yeah" and workbook would be opened in read-only mode. So changes cannot be made to the original workbook. To save changes, y'all just could create a new copy of the workbook and give it a new name, or save workbook in another location.

Pick 2:

Select "No" and excel workbook would not be opened in read simply style. You tin can change workbook and save changes this time. Just when y'all save and open up this workbook next time, you would notice this workbook still recommend you to open information technology as read but.

Tips:

If you take checked "Read-only recommended" in MS Excel, and then every excel workbook yous create later would be checked by default. It means all of workbook would exist recommended to open in read just mode when y'all try to open up them.

Way 3: Set Modify Password to Protect Workbook in Read Only Way

To directly protect workbook from editing, I recall the common way is to set a modify countersign on it.

1. In Excel Save As dialog, click Tools and select Full general Options.

2. And so in General Options dialog, you can enter a password in box "Countersign to modify" and click OK, to protect workbook with modify password from editing.

3. Click Relieve button in Save Every bit dialog to save workbook and replace the original i.

So while you open the Excel workbook next time, a dialog would always pops up and asks for a countersign for write access. Otherwise, you simply could open the workbook read only.

Way 4: Protect Workbook Structure to Forestall Unwanted Changes

If you just desire to prevent unwanted changes to the structure of workbook, such as adding/moving/deleting sheets, y'all tin can choose to protect Workbook Structure.

1. Click File > Info and select Protect Workbook Structure under Protect Workbook.

Or click Review tab and select Protect Workbook choice in Changes group.

ii. On post-obit Protect Structure and Windows dialog, cheque "Structure" and "Windows" in order to protect workbook structure and windows.

3. Now you lot could also set a password to protect information technology, then only people who know the password could modify your Excel Workbook construction. Click OK at last.

Manner 5: Protect sheets in Workbook to keep read just

1. Navigate to each sheet in Workbook yous desire to continue information technology read just.

2. Click Review tab and Protect Sheet in Changes group.

3. Enter password to protect canvas and click OK in dialog "Protect Sheet".

And then when you want to edit sheet, you would exist prompted that "The cell or nautical chart is protected and read-only". Simply after removing protection, can you change a protected prison cell or chart.

Tips: There is another style you could as well protect workbook from editing. That is encrypting Workbook with password to prevent workbook from opening.

When you cannot open excel workbook, so you lot cannot brand any changes to this workbook, unless you lot tin recover excel password or remove excel password. In one case yous have workbook open countersign or successfully remove open password, you would be able to do annihilation you want on excel workbook.

Related Articles:

• How to Add or Remove Password Protection in Excel 2016 Spreadsheet
• How to Remove Workbook Protection Excel 2010 without Password
• How to Protect Multiple Sheets in Excel 2010 Workbook
• Forgot Excel Workbook 2010/2013/2016 Countersign
• How to Unlock Encrypted Excel Spreadsheet without Countersign

fritzgoiderearsur.blogspot.com

Source: https://www.isunshare.com/blog/set-excel-workbook-read-only-to-restrict-changes/

Share this post