Jennifer, Here Are Your Articles for Wednesday, January 25, 2017
Is this email not displaying correctly?
View it in your browser .
Share Save

Here's Help for an Excel Spreadsheet Issue


Many Excel users release a sigh of frustration every time the Protected View prompt appears at the top of the screen in Excel 2010 and later. This is most likely to appear when you open a spreadsheet that someone has emailed you, but it can also arise when Excel considers your local network to be the Internet. Protected View is intended to allow you to look at a spreadsheet to determine if it's safe to edit or not. You can't miss it because Excel's ribbon user interface collapses and virtually all functionality in Excel is disabled except for navigating the workbook and copying cells to the clipboard. If you wish to edit that individual spreadsheet, you must click the Enable Editing button. Over the course of a day it can be frustrating to click the Enable Content prompt multiple times as you cycle through various spreadsheets.

Such security measures often solve one problem and create others. Fortunately, you can control it if and when Excel uses Protected View as shown in the image below:

Most users will want to clear Enable Protected View for Outlook attachments. You may also wish to clear the first option as well, but all users should keep the middle option in place. Keep in mind that you can always manually trigger Protected View if you want to look at a document with unknown provenance. To do so:

  1. Click once on the file name within Excel's Open dialog box.
  2. Click the down-arrow button along the right edge of the Open button.
  3. Choose Open in Protected View from the submenu that appears.

From there you can choose whether to enable content or not by way of the prompt that will appear at the top of the screen.

Would you like to learn how to use Excel more efficiently? We offer training in it! Contact to learn more.

Share Save

Your Comments

Out Of The Box Technology
out of the box technology
7150 SW Hampton Suite 200
Tigard, OR 97223
Friend Me on Facebook
Follow Me on Twitter
Connect with me on LinkedIn
Saved Articles
Comments and Feedback
Refer A Friend
Your Privacy
Our firm provides the information in this e-newsletter for general guidance only, and does not constitute the provision of legal advice, tax advice, accounting services, investment advice, or professional consulting of any kind. The information provided herein should not be used as a substitute for consultation with professional tax, accounting, legal, or other competent advisers. Before making any decision or taking any action, you should consult a professional adviser who has been provided with all pertinent facts relevant to your particular situation. Tax articles in this e-newsletter are not intended to be used, and cannot be used by any taxpayer, for the purpose of avoiding accuracy-related penalties that may be imposed on the taxpayer. The information is provided "as is," with no assurance or guarantee of completeness, accuracy, or timeliness of the information, and without warranty of any kind, express or implied, including but not limited to warranties of performance, merchantability, and fitness for a particular purpose.
Powered by
Copyright © IndustryNewsletters All rights reserved.

This email was sent to:

Mailing address: 7150 SW Hampton, Suite 200, Tigard, OR 97223