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:
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
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!