Patrick Wacker
asked on
Excel at startup prompt "this document is both encrypted and password protected"
Hello,
Whenever I start up Excel, I am getting the prompt "This document is both encrypted and password protected. The Office Open XML Formats available in Office 2007 and later provide stronger encryption. Do you want to increase the security of this document by converting to an Office Open XML document?"
However, I am not opening a file when starting Excel. No file opens either once Excel has started.
I am using Excel for Windows. Version: Office 365 MSO (16.0.11601.20174). Installed on my computer (not the web version). I am running Windows 10.
Any help with this error would be much appreciated. Thanks.
Whenever I start up Excel, I am getting the prompt "This document is both encrypted and password protected. The Office Open XML Formats available in Office 2007 and later provide stronger encryption. Do you want to increase the security of this document by converting to an Office Open XML document?"
However, I am not opening a file when starting Excel. No file opens either once Excel has started.
I am using Excel for Windows. Version: Office 365 MSO (16.0.11601.20174). Installed on my computer (not the web version). I am running Windows 10.
Any help with this error would be much appreciated. Thanks.
Just a quick guess... Possibly a startup macro running?
I know in Word, the default blank document that opens when you open a new file is called Normal.dot or .dotm. In Excel, though, it's a little different but the principle is the same.
On your PC, look at C:\Users\yourusername\AppD ata\Roamin g\Microsof t\Excel\XL START and see if there are any templates in there. It's possible something got saved or corrupted and it's defaulting to that file when you start Excel.
Here's some more info on XLSTART folder - https://support.office.com/en-gb/article/customize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19
On your PC, look at C:\Users\yourusername\AppD
Here's some more info on XLSTART folder - https://support.office.com/en-gb/article/customize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19
you can also do a repair on excel - or Office
ASKER
Unfortunately, none of the above solved the issue.
No macro is running at startup. I did the extended repair as suggested by nobus without any change when starting up Excel.
I also created a personal file in the XLSTART folder as suggested by https://www.experts-exchange.com/questions/29147726/Excel-at-startup-prompt-this-document-is-both-encrypted-and-password-protected.html?anchorAnswerId=42875612#a42875612
since I was hoping that Excel would read this file at startup. This did not work but was worth a try.
No macro is running at startup. I did the extended repair as suggested by nobus without any change when starting up Excel.
I also created a personal file in the XLSTART folder as suggested by https://www.experts-exchange.com/questions/29147726/Excel-at-startup-prompt-this-document-is-both-encrypted-and-password-protected.html?anchorAnswerId=42875612#a42875612
since I was hoping that Excel would read this file at startup. This did not work but was worth a try.
Are you admin? You can try turn it off.
[HKEY_CURRENT_USER\Softwar e\Microsof t\Office\1 2.0\Common \Security] "NoPromptF orRC4Encry ption"=dwo rd:0000000 1
[HKEY_CURRENT_USER\Softwar
Have you tried running Excel under another user account? If you don't have another account, create one. This will tell you whether it's something in Excel or in the user's profile.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
https://support.microsoft.com/en-us/help/826922/how-to-prevent-files-from-opening-automatically-in-excel