SOLVED
Home

Creating Read-Only Files on Version 1905

%3CLINGO-SUB%20id%3D%22lingo-sub-724702%22%20slang%3D%22en-US%22%3ECreating%20Read-Only%20Files%20on%20Version%201905%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724702%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20previous%20versions%20of%20Excel%2C%20I%20used%20the%20%3CSTRONG%3E%3CEM%3Efile%3C%2FEM%3E%3C%2FSTRONG%3E%20read-only%20option%20quite%20extensively.%20This%20allows%20anyone%20to%20click%20on%20an%20Excel%20file%20to%20open%20it%2C%20whereby%20a%20password%20prompt%20appears.%20Entering%20the%20password%20allows%20the%20user%20full%20read%2Fwrite%20access.%20If%20you%20don't%20have%20the%20password%2C%20you%20can%20click%20on%20'Read%20Only'.%20The%20file%20will%20then%20open%20but%20it%20will%20not%20allow%20the%20file%20to%20be%20saved%20under%20the%20same%20name%2C%20only%20as%20'Save%20as'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20office%20was%20recently%20upgraded%20to%20Office%20365pro%20version%201905.%20The%20whole%20protection%20scheme%20appears%20to%20have%20been%20changed.%20I%20have%20spent%20the%20last%20couple%20of%20hours%20trying%20to%20get%20one%20of%20the%20many%20new%20permutations%20(some%20with%20cryptic%20descriptions)%20that%20corresponds%20to%20the%20option%20described%20above.%20However%2C%20this%20no%20longer%20seems%20to%20be%20available.%20I%20can%20set%20a%20file%20so%20that%20it%20can%20only%20be%20opened%20with%20a%20password%20(but%20then%20those%20without%20the%20password%20can't%20open%20it)%2C%20I%20can%20set%20a%20workbook%20so%20that%20certain%20sheets%20can%20be%20protected%20(but%20can%3Bt%20stop%20them%20creating%20new%20sheets)%2C%20I%20can%20set%20a%20sheet%20so%20that%20certain%20cells%20can%20be%20protected%20(ditto)%2C%20and%20I%20can%20set%20a%20workbook%20so%20that%20certain%20named%20email%20addresses%20have%20access%20(which%20restricts%20it%20from%20general%20access).%20But%20I%20can't%20seem%20to%20simply%20write-protect%20a%20whole%20file%20any%20more%20while%20still%20allowing%20anyone%20to%20open%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20some%20way%20of%20doing%20this%20on%20version%201905%20that%20I'm%20not%20aware%20of%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditionally%2C%20is%20there%20a%20way%20for%20me%20to%20change%20the%20existing%20password%20on%20older%20Excel%20files%20versions%20that%20have%20the%20old%20read-only%20file%20protection%20enabled%20without%20losing%20this%20function%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20to%20anyone%20who%20can%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-724702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724837%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Read-Only%20Files%20on%20Version%201905%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724837%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367591%22%20target%3D%22_blank%22%3E%40craig1965%3C%2FA%3E%20If%20you%20click%20File%2C%20Save%20a%20Copy%20you%20can%20click%20the%20More%20options%20link%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121474i93E11E674EBF734B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-06-27_13-52-21.jpg%22%20title%3D%222019-06-27_13-52-21.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAfter%20that%2C%20the%20normal%20save%20dialog%20opens%20and%20you%20can%20click%20the%20Tools%20drop-down%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20683px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121475iAE8A189D648CC3F2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-06-27_13-54-06.jpg%22%20title%3D%222019-06-27_13-54-06.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724844%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Read-Only%20Files%20on%20Version%201905%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724844%22%20slang%3D%22en-US%22%3ENB%3A%20In%20File%2C%20Options%2C%20Save%20tab%20you%20can%20control%20whether%20or%20not%20Excel%20displays%20the%20new%20save%20backstage%20screen%20or%20the%20old-style%20save-as%20dialog%20when%20you're%20either%20using%20short-cut%20keys%20(F12)%20or%20when%20you%20use%20the%20save-as%20button%20which%20you%20can%20add%20to%20your%20QAT.%20File%2C%20Options%20general%20also%20enables%20you%20to%20disable%20the%20startup%20screen%20taking%20you%20directly%20to%20an%20empty%20file%20(bottom%20checkbox)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724853%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Read-Only%20Files%20on%20Version%201905%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724853%22%20slang%3D%22en-US%22%3EGreat.%20Thanks%20a%20lot.%20Exactly%20what%20I'm%20looking%20for!%3C%2FLINGO-BODY%3E
craig1965
New Contributor

On previous versions of Excel, I used the file read-only option quite extensively. This allows anyone to click on an Excel file to open it, whereby a password prompt appears. Entering the password allows the user full read/write access. If you don't have the password, you can click on 'Read Only'. The file will then open but it will not allow the file to be saved under the same name, only as 'Save as'.

 

Our office was recently upgraded to Office 365pro version 1905. The whole protection scheme appears to have been changed. I have spent the last couple of hours trying to get one of the many new permutations (some with cryptic descriptions) that corresponds to the option described above. However, this no longer seems to be available. I can set a file so that it can only be opened with a password (but then those without the password can't open it), I can set a workbook so that certain sheets can be protected (but can;t stop them creating new sheets), I can set a sheet so that certain cells can be protected (ditto), and I can set a workbook so that certain named email addresses have access (which restricts it from general access). But I can't seem to simply write-protect a whole file any more while still allowing anyone to open it.

 

Is there some way of doing this on version 1905 that I'm not aware of?

 

Additionally, is there a way for me to change the existing password on older Excel files versions that have the old read-only file protection enabled without losing this function?

 

Thanks to anyone who can help.

3 Replies

@craig1965 If you click File, Save a Copy you can click the More options link:

2019-06-27_13-52-21.jpg

After that, the normal save dialog opens and you can click the Tools drop-down:

 

2019-06-27_13-54-06.jpg

Solution
NB: In File, Options, Save tab you can control whether or not Excel displays the new save backstage screen or the old-style save-as dialog when you're either using short-cut keys (F12) or when you use the save-as button which you can add to your QAT. File, Options general also enables you to disable the startup screen taking you directly to an empty file (bottom checkbox)
Great. Thanks a lot. Exactly what I'm looking for!