Excel file password protection without restriction about 7 characters minimum

Copper Contributor

Hi expert team,

 

Everyday, i used passwords to protect my excel files before sending them to my clients.

When i have to choose the password, there is always a restriction with a minimum of 7 characters to choose with uppercase, lower case, numbers or specific characters.

 

I would love to be able to choose the password i want without any restrictions.

For example: 123

 

Do you think is it possible to configure excel and remove this restrictions ?

if it's possible outside excel with a specific software, please tell me ^^

 

best regards,

Nicolas

8 Replies

Hi @NicolasB1990 

 

What version of Excel are you using?

 

I just encrypted my file with 123 as the password

Hi @Wyn Hopkins 

 

I'm not sure as it's my work computer but i think it's office 16 (refer to picture attached)

@NicolasB1990 

 

Is this setting available in your version?

 

 

 

image.png

 

 

Or do you go via this method

image.png

 

 

Hi @Wyn Hopkins 

 

i used the 1st method ( i don't know how to use the 2nd method)

NicolasB1990_0-1611830028495.png

but my colleague used the 2nd method and have the same problem

NicolasB1990_1-1611830094603.jpeg

 

How do i use the 2nd method ?

 

 

@NicolasB1990 

 

Maybe this information will help you.

 

Instructions with video with different encryption possibilities of a worksheet or workbook from Microsoft.

 

Protect an Excel file

https://support.microsoft.com/en-us/office/protect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b59...

 

I would be happy to know if I could help.

 

I wish you continued success with Excel

 

Nikolino

I know I don't know anything (Socrates)

Odd, it might be some organisation setting. I'll ask around and let you know

@NicolasB1990 

As Mr. Wyn Hopkins  has already described, this could also be set in the organizational settings or Windows Server settings.

 

Here is some information from Microsoft, maybe this link will help you.

 

AD DS Fine-Grained Password and Account Lockout Policy Step-by-Step Guide

https://docs.microsoft.com/de-de/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc...

 

It would be best if you insert a file (without sensitive data) with this problem, where you could possibly take out a better solution.

 

Wish you and all others in this Post a nice day / night with lots of health, joy and love.

 

Nikolino

I know I don't know anything (Socrates)

Hi, have you got the solution for this. I'm getting 14 char must message..