Excel 2016 only opens workbooks in Read-Only Mode - How to disable this feature and default to Edit Mode?

Previous versions of Excel I've used don't have this feature set by default and I would like to disable this for the Excel Files I'm working with.
This stand alone Excel 2016 installation is running on a Windows 2012 R2 Server.

Thanks
Brian EsserZone Technology ExpertAsked:
Who is Participating?
 
crystal (strive4peace) - Microsoft MVP, AccessConnect With a Mentor Remote Training and ProgrammingCommented:
File, Options, Trust Center,  Trust Center Settings..., File Block Settings --> check Open selected file types in Protected View and allow editing. Check all file types to Open Excel File, Options, Trust Center,  Trust Center Settings, File Block Settings
0
 
Brian EsserZone Technology ExpertAuthor Commented:
Thanks!
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
correction: on the OPEN checkbox ... UNCHECK it if you do not wish rules to be applied.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.