"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
Highlighted
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
Highlighted

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

Highlighted

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?