Link to home
Start Free TrialLog in
Avatar of Patrick Wacker
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.
Avatar of Jim Faust
Jim Faust
Flag of United States of America image

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\AppData\Roaming\Microsoft\Excel\XLSTART 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
you can also do a repair on excel - or Office
Avatar of Patrick Wacker
Patrick Wacker

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.
Are you admin? You can try turn it off.

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Security]"NoPromptForRC4Encryption"=dword:00000001
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 TRIAL
Members 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.