Error: "The password you supplied is incorrect.Verify the CAPS LOCK key is off..."

[Veeman23]

Good Day

I recently upgraded two user to Win 10 and Office 2016 but they cannot open an excel protected password while other user can open it with the very same password. Any help please.

[h=2]Error: "The password you supplied is incorrect.Verify the CAPS LOCK key is off..."[/h]

 

[Peter_SSs]

Welcome to the MrExcel board!

Does the password contain any digits? If so, and the users are using the number keypad to enter those digits they should also check that 'num lock' has not been turned off.

 

[Veeman23]

Welcome to the MrExcel board!

Does the password contain any digits? If so, and the users are using the number keypad to enter those digits they should also check that 'num lock' has not been turned off.

Dear Peter

Yes the password contain digits and I have tested with users who are still on office 2013 and 2010. I think the problem is with MS Excel 2016

 

[RoryA]

It’s not something I’ve heard of and I think it would be pretty widespread if it were a bug in 2016. How sure are you that the user doesn’t actually have caps lock on, and is typing the password correctly?

 

[Veeman23]

It’s not something I’ve heard of and I think it would be pretty widespread if it were a bug in 2016. How sure are you that the user doesn’t actually have caps lock on, and is typing the password correctly?

Dear RoryA

I am 100% sure because I have tried it myself and it worked those users who are running office 2010 and 2013.

 

[RoryA]

If you password protect a workbook on the 2016 machine, can it be opened on one of the other machines?

 

[Veeman23]

If you password protect a workbook on the 2016 machine, can it be opened on one of the other machines?

I haven't tried that I will test and get back to you.