Password Security a bit OTT ?

[velohead]

Hi All,

I have some spreadsheets that have a 'low strength' password because the the data is not in the realms of national security, but equally I would like to deter casual browsing.
If the password is broken at some point, than it is no big deal. At all.
I have a lot of spreadsheets with the same historical password, and a lot of authorised spreadsheet users that know the password. The password is quick to type as the files are used often.

However, when I try to save a new spreadsheet XL is not happy unless I provide a long cumbersome strong password, which in this situation is not required as per above comments.

How do I turn off the super_strenth_state_secret_s**t and just have a low strength casual password ?

 

[6StringJazzer]

What version of Excel do you use and how are you applying the password? When I go to File, Info, Protect, Encrypt, it lets me use any password I want.

 

[velohead]

Using Excel 365 - sorry, should have said.
Even when saving as .xls it still needs a strong password.

Create New File
Save as...
Tools (on bottom right of Save As)
General Options
Password to open

Resulting Message:
The password supplied does not meet the minimum complexity requirements

 

[MARK858]

That sounds more like a domain requirement rather than an Excel warning.

 

[velohead]

No worries, you may be correct as the company has quite sophisticated controls.

 

[MARK858]

You're welcome

 

[6StringJazzer]

I have no tools on the bottom right of Save As. Are you using the browser-based version?

 

[Fluff]

Not sure if this is relevant, but do you have a "sensitivity" button on the home tab?

 

[velohead]

I have no tools on the bottom right of Save As. Are you using the browser-based version?

hehehe, I am so lazy and old school, that's partly why I love vba. My QAT is at capacity, I would love a second row.
I wont say how big my vba library in module one is, but it's big ! (That's were I 'file' my semi-frequently and often used macros)
To answer your question, when I save as, I just press the 'save as' button on my QAT. I've been doing that for the last 15 years so never go the long way round.

If I go the long way.....
File
save as
browse
now there are three items on bottom left corner....
Tools (drop down) + Save Button + Cancel Button.

Tools
General Options
Password to open.

 

[velohead]

Not sure if this is relevant, but do you have a "sensitivity" button on the home tab?

The sensitivity drop down (on home tab) is greyed out.

I've never heard of that before, or noticed it for that matter, but it is there at extreme right hand side.