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!
Thanks for the very helpful tip!!! Saved me lots of time and frustration!
Thanks, you are a life saver!
you’re welcome
yes, this is so helpful to me. i’ve been stuck with this for 3 days. Thanks a lot.
you’re welcome
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?
THANKS FOR THE HELPFUL TIP!
Thanks a lot bro
A big Thanks to you Dear!
The “solution” is to just make your machine unsafe and randomly open files from the Internet?
Huh?
Why can’t the (many) bugs in Excel just be f-i-x-e-d instead?