How best to upgrade Microsoft Office 2010?
This question is about Microsoft Office. I mostly use Google Docs and Google Sheets, as opposed to Microsoft Office. For my usage anyway, they work just as well or better than M-soft Office because ...
Forum Discussion
crcr wrote:
OK, thanks for that suggestion. I just tried doing exactly that, and Excel still will not open the file. It just stays stuck on the dialog box and never opens:
"Microsoft Excel 2010
Opening in Protected View"
Thanks to everyone for all your tips and suggestions. At least I am able to open the file in Libre Office.
Ahh.. That IS the real problem.
Starting with 2010, MS and their continual reaching for higher and higher stupidity levels of stopping folks from accidentally opening potentially virus compromised files decided to totally cripple all of the Office products with over the top "security" defaulted to the max setting.
Pretty smart of them to forget to tell everyone, so one must discover this totally by accident then have to figure out just why this software can not open files that it should be able to open.
Yeah, they have even hid how to fix the problem that should not have been a problem but none the less it is and up to the end user to figure out how to fix..
OK, your gonna love this, you have to go into the "Trust Center" to find the settings to disable this stupid Protected view..
BUT, that may not be enough, seems that sometimes Office 2010 decides to be stubborn and even though you disable the Protected view settings it refuses to open the documents and may require additional probing in the Registry (must be careful in there, make the wrong change and you might have to reload Windows and all of your software)..
I don't have a copy of 2010 handy so I can't walk you through this.
So, "google" is your friend here, search for disabling protected view in Office 2010.
Found the following info on MS "Technet" forum which may be helpful to you.
READ HERE
At least Libre is working for you and that is a plus, I hate when things just don't work the way they are supposed to.
If you disable Protected view, I would recommend a reboot of your PC after making changes in hopes that might stop the Protected view nanny without the need to rummage through the Registry.
Sadly though, IF you are using "Win10 HOME" you will not have the Registry editor to fall back on (yeah MS scrubbed one of the most important parts of Windows to keep Home users from meddling in MS affairs under the hood)..
Kind of like removing the transmission dipsticks in the engine compartment so one can't check if you have proper level of transmission fluid..
