How To Manage Protected View In MS Excel

Everyone wants to export the report of QuickBooks Online to Excel 2010 or later is familiar with Excel’s Protected View Features. In protected view features you can only see but not edit such document until you grant permission within an on-screen prompt

The protected view allows you to open Excel spreadsheets in a view-only mode that can’t harm your computer. Excel spreadsheets can sometimes have malicious programming codes or data connections, so a protected view is required. By default Excel 2010 files open from the Internet, e-mail also attached. This feature gives you when you open a sheet that has been emailed you always with a location. Read this or talk to a QuickBooks ProAdvisor for further information related to this topic.

However, security measures often solve a problem and make new ones. As you have seen, you can not make any changes in a spreadsheet or use any Excel features unless you click on Enabled Editing on each Email Attachment or Report. In this article, I describe how you can close Excel’s protected view feature in most cases, while still able to open the spreadsheet of unknown origins in protected view mode.

Default Excel 2010 and later look from the beggar when you open the following type of sheet.

  • Spreadsheets open by the Internet, such as those hosted on the website or generated by an online platform like QuickBooks Online and an online email system such as Gmail.
  •  Outlook attachment, that spreadsheet have been emailed you.
  • I have also seen situations where Microsoft Excel mistakenly understands the local network of an organization on the Internet, which means that protected views are triggered for each document that the user opens from the network location.

Above image shows what happen you open sheet protected view.

  • Excel message bar display security prompt.
  • All worksheets cells are protected.
  • Most of the command within Excel’s menu is disabled.

If you do not click on Enable Editing on the message bar the entire sheet are trapped under glass until.

The protected footage will appear in Excel’s title bar, as shown in the above image, and in the message bar. If you either stop the message bar intentionally or accidentally, you still have a medium through which you can exit the protected scene.

  1. Select Excel’s File.
  2. Select Info.
  3. Click Enable Editing.

The downside of the protected view is that it contributes to the “death of 1000 cuts” experience in Excel where we are unknowingly subject to unnecessary repetitive tasks. If you are familiar with the type of documents that you open in Excel, you can safely close the protected view, especially if you confirm some other security settings in Excel that I will share.

If you are presently working with a document in Protected View after that you click Protected View Settings to get the area in Excel spreadsheets where we manage this setting. Alternatively, shows another path to these settings:

  1. In QuickBooks Select the Excel’s File.
  2. Then Click on the Options.
  3. Select Trust Center with the left-hand side of the Excel Options dialog box.
  4. Click the Trust Center Settings button to the right of the Options dialog box.
  5. Select Safe View from the Trust Center dialog box.
  6. If you feel comfortable doing this, uncheck the “Enable Protected View for files generated from the Internet” checkbox. This will speed up the process of working with files you export from QuickBooks Online and other cloud-based software.
  7. You may wish to uncheck the Enable Protected View for Outlook Attachments checkbox.
  8. Everyone should be able to “Enable Protected View” option for files located in potentially unsafe locations. Whether you want to disable Protected View or not, there are some other settings that you should review in Excel Trust Center.
  9. Select macro settings in Excel’s Trust Center dialog box.
  10. Make sure that your macro settings are set to disable all macros with notification.

The programming code (Macros) that can be embedded within Excel spreadsheets. You may receive spam emails with spreadsheets or word documents that include unpaid invoices. Depending on this social engineering method, hackers are hoping that you will open the document open. Which can be set to automatically launch programming code when the file is opened. The “Disable all macros with notification” prompt causes a macro security signal to be displayed instead of a protected view so that you can decide with a purpose whether to enable macros or not. 

  1. Select external content within Excel’s Trust Center dialog box.
  2. The security settings for the data connection should be set to “User signals about the data connection”.
  3. Security settings for workbook links should be set to the immediate use on automatic updates for workbook links.
  4. For close the Trust Center you could click on OK.
  5. To close the Excel Options dialog box also click on OK.

Files from the Internet and other potentially vulnerable locations can be viruses, worms or other types of malware that can harm your computer. To help protect your computer, files of these potentially vulnerable places are opened in read-only or protected scenes. Using a protected view, you can read a file and view its content and enable editing while reducing risk.

At this point you can experience unwanted signals to enable macros, updating workbook links, or refreshing data connections within workbooks that you use most often. Depending on the case, you can suppress these signs in any case.

When a message bar prompts related to macros, workbook links or data connections appear, do not click on the Enable content button.

Instead, click on Excel’s File menu.

Select the info tab in which one second enabled content will be prompted.

Click on enabled content.

From the Enable Content prompt, select Enable All Content. In most cases, this command will basically say “make this a trusted document”.

Once you consider a document to be reliable, you know longer have to face a message bar signals, which means that you can easily use macros, as well as update workbook links and data connection automatically. When you open unfamiliar documents, facing this protective gesture, you can open documents often used in this fashion efficiently. Basically, you always have the option the document in a protected view, and can view in the below image:

  1. To launch Excel’s Open Dialog Box, press ctrl+O or use the file menu to manually navigate to the Open Dialog Box.
  2. Click once on the document name.
  3. Click on the arrow to the right of the Open button.
  4. Select Open in Protected View.


As we discussed above, with Managing Protected View in Microsoft Excel in QuickBooks now you can easily manage your Spreadsheets. If you any need further then you can contact our QuickBooks Support team. And you simply dial our toll-free number, they will assist you technically and help you to solve your problem with the best method.