Wondering if passwords are "buggy" in Excel

Ruthanne

Board Regular
Joined
Mar 2, 2004
Messages
123
Are passwords know to inexplicably change/bug in Excel (I am using 2003).
I only use one password for all my workbooks I make at my office & one rather complicated one no longer accepted my password. It is highly unlikely that co-workers "figured out" my password AND reprotected it using theirs (most don't use Excel & don't do practical jokes) but internet research didn't indicate this is a problem. I would like to know because if it is a problem I will start using the blank/default protection & hope for the best (the last incident was tedious to recover from!)
Thanks!
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,079
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
It's not an issue I've ever experienced (I guess you are talking about passwords to open the workbook rather than worksheet/book modify passwords?) but it might be possible if your workbook were becoming corrupted.
 

Ruthanne

Board Regular
Joined
Mar 2, 2004
Messages
123
oops, I apologize for mixing that up...I meant the protection password on the individual worksheets.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,079
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I'm not aware of any issue with those changing, but it is much easier to crack a worksheet password (no matter what it is, it can be broken in about a minute using plain VBA) so it may be a bit more likely that someone else is responsible. Do you have any code that protects/unprotects the worksheets?
 

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,793
Office Version
  1. 2019
Platform
  1. Windows

ADVERTISEMENT

I've not heard of problems with passwords bugging out before... AB
 

Ruthanne

Board Regular
Joined
Mar 2, 2004
Messages
123
Aha! I should have known you experts could crack it...though I think there's online "products" one can order also.
I checked the workbook & there was no protection code in the VBA (and also this password problem happened before I added the slew of VBA/command buttons recently).
I agree with something I recently read on an MVP post: most things we accidentally do ourselves. I must've typo'd my password...twice! I think that's more probable then the other possibilities especially if this is not a known bug.
Thanks a mil!
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
There are plenty of ways to crack passwords, but it's board policy not to disclose them here. Just a heads up. ;)

But I've never heard of passwords getting wonky.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,670
Messages
5,597,482
Members
414,144
Latest member
UDFNewbie

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top