Solved

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

Posted on 2016-09-24
4
1,844 Views
Last Modified: 2016-09-24
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
0
Comment
Question by:BrianEsser
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 21

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 500 total points
ID: 41814081
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
 

Author Closing Comment

by:BrianEsser
ID: 41814147
Thanks!
0
 
LVL 21
ID: 41814154
you're welcome ~ happy to help
0
 
LVL 21
ID: 41814321
correction: on the OPEN checkbox ... UNCHECK it if you do not wish rules to be applied.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question