0

excel logo

When opening Excel spreadsheets from unknown sources, a feature in Excel called Protected View shields you from potential risks. This is great, but to work on the document, you will need to switch to editing mode.

How to Switch to Editing Mode

Protected View is switched on by default. So whenever you open a file that originated from a website or that you received via email, you are taken to Protected View.

The message bar will appear along the top of the document and offer you the chance to enable editing. Click the “Enable Editing” button.

Protected View with Enable Editing button

The document is now opened as read-only with some content disabled.

Read Only view

Save the document to another location to be able to work on it effectively.

Why Use the Protected View?

Protected View protects you from malware, viruses, and threats that you can be exposed to when opening Excel files from unknown sources. These sources include a website, email attachments, and other unsafe locations such as shared drives.

Read the remaining 11 paragraphs


Post a Comment Blogger

We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.

 
Top