Home

"Read-Only" Workbook Copied and Saved-As Keeps Prompting Read-Only Message - How to Stop?

%3CLINGO-SUB%20id%3D%22lingo-sub-294664%22%20slang%3D%22en-US%22%3E%22Read-Only%22%20Workbook%20Copied%20and%20Saved-As%20Keeps%20Prompting%20Read-Only%20Message%20-%20How%20to%20Stop%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-294664%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BI%20have%20an%20Excel%20workbook%20that%20is%20password%20protected%20so%20it%20can%20only%20be%20opened%20as%20%22Read%20Only%22.%26nbsp%3B%20Users%20are%20instructed%20to%20open%20the%20document%20as%20%22Read-only%22%20and%20then%20%22Save%20as%22%20so%20they%20can%20use%20the%20document%20as%20their%20own%20document.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20renaming%2C%20saving%20as%2C%20closing%20the%20document%20and%20then%20reopening%20the%20document%2C%20the%20user%20is%20the%20prompted%20with%20the%20message%20stating%20%22The%20author%20would%20like%20you%20to%20open%20'Name%20of%20document'%20as%20read-only%20unless%20you%20need%20to%20make%20changes.%20Open%20as%20read-only%3F....%20Yes-No-Cancel%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20eliminate%20this%20secondary%20message%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20once%20a%20document%20has%20been%20saved%20as%20a%20new%20document%2C%20that%20prompt%20should%20no%20longer%20appear.%3C%2FP%3E%3CP%3EIt's%20very%20confusing%20to%20people.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EJeff%3C%2FP%3E%3CP%3E%26nbsp%3BExcel%202016%26nbsp%3B%20(16.0.8431.2110)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-294664%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-294898%22%20slang%3D%22en-US%22%3ERe%3A%20%22Read-Only%22%20Workbook%20Copied%20and%20Saved-As%20Keeps%20Prompting%20Read-Only%20Message%20-%20How%20to%20St%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-294898%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20responding%2C%20but%20I'm%20not%20sure%20what%20I%20should%20be%20looking%20for%20to%20address%20the%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20settings%20should%20I%20have%20to%20eliminate%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-294667%22%20slang%3D%22en-US%22%3ERe%3A%20%22Read-Only%22%20Workbook%20Copied%20and%20Saved-As%20Keeps%20Prompting%20Read-Only%20Message%20-%20How%20to%20St%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-294667%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20your%20settings%20in%20backstage%3A%26nbsp%3B%20Files%20%26gt%3B%20Info%20%26gt%3B%20Protect%20Workbook%3C%2FP%3E%3C%2FLINGO-BODY%3E
Jeff_2018
New Contributor

 I have an Excel workbook that is password protected so it can only be opened as "Read Only".  Users are instructed to open the document as "Read-only" and then "Save as" so they can use the document as their own document.

 

After renaming, saving as, closing the document and then reopening the document, the user is the prompted with the message stating "The author would like you to open 'Name of document' as read-only unless you need to make changes. Open as read-only?.... Yes-No-Cancel"

 

Is there a way to eliminate this secondary message?

 

It seems once a document has been saved as a new document, that prompt should no longer appear.

It's very confusing to people.

 

Thank you

Jeff

 Excel 2016  (16.0.8431.2110)

2 Replies

Check your settings in backstage:  Files > Info > Protect Workbook

Thank you for responding, but I'm not sure what I should be looking for to address the issue.

 

What settings should I have to eliminate this issue?

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
204 Replies