Link to home
Start Free TrialLog in
Avatar of dlmyersdta
dlmyersdta

asked on

Read-Only Microsoft 2016 Excel Workbook/Outlook 2016

We have users who receive spreadsheets via Outlook. We recently just upgraded from Office 2007 to 2016. When the users opens the document from Outlook, the document is automatically converted to read-only mode. Is there a way to change the configuration in Outlook/Excel 2016 to disable the read-only mode? so users will not have to save an attachments for each e-mail before they are able to modify a spreadsheet? Any suggestions or ideals are welcome.

Many Thanks,
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Dear user
To disable read only mode in Outlook 2016 follow these steps:

1. Open Microsoft Outlook 2016
2. Go to File Menu
3. Click on Options
4. In Option Window you'll find "Trust Center"
5. Click on "Trust Center Settings" button
6. It will Open a "Trust Center Window" in that uncheck the Enable protected View for Outlook attachments.
7. Now choose File Block setting on the left Pane. Click on Restore Defaults.
From now your attachment will open in Read/Write mode

Thanks & Regards
Edwin Hoffer
Avatar of dlmyersdta
dlmyersdta

ASKER

Edwin,

Good morning. Do you mean apply these steps in Excel? I've applied these steps and attempted to open an Excel spreadsheet from Outlook and it still displays Read-Only Mode.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- David Johnson CD MVP (https:#a41857543)
-- Edwin Hoffer (https:#a41859745)


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk
Experts-Exchange Cleanup Volunteer