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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies