Excel file does not open, Its stuck indefinitely in “opening in protected view” stage

Standard

I downloaded an Excel file (It had the PowerPivot Model) from Internet on my Windows Server Dev Machine. When I tried opening that file on my machine it got stuck in the “Opening in protected View” stage:

excel opening in protected view message

I was able to solve the issue and I would document how I did that in this blog-post:

1. Go to START > Open Excel

2. Go to File > Options > Trust Center > Trust Center Settings

excel 2010 trust center settings

3. In the Trust Center. Go to Protected View

Here you can disable the Protected View based on your needs.

Since I wanted to open a file that originated from Internet, I disabled “Protected View for files originating from the Internet”.

Clicked on OK.

4. Now go to File > Open that FILE!

Once you are done, You can enable the protected view. Important!

So That’s about it for this post, I hope it was helpful!

10 thoughts on “Excel file does not open, Its stuck indefinitely in “opening in protected view” stage

  1. Not helping 🙁
    I downloaded and installed office 2010. Now when opening Excel files that have been on my PC for years which are updated every month are all of a sudden opening in protected view and I cannot edit them. I uncheck ALL the boxes in “Trust center” and still the files open in protected view.
    Any suggestions?

What do you think? Leave a comment below.