My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Cancel password for excel file|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Cancel password for excel file|General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Cancel password for excel file
Avatar
lea cohen
Member
Members
Level 0
Forum Posts: 222
Member Since:
March 10, 2016
sp_UserOfflineSmall Offline
1
November 30, 2018 - 5:48 pm
sp_Permalink sp_Print

Hi,
I have encrypted an Excel file with a password, the password is known to me and I want to unencrypt and the file will open normally without a password, how do I do this?
Thanks

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1530
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
2
November 30, 2018 - 5:57 pm
sp_Permalink sp_Print

Hi Lea,

So you mean encrypted as in you encrypted it in Windows using BitLocker or EFS?  Or is it just that the file is password protected?

Regards

Phil

Avatar
Velouria
London or thereabouts
Moderator
Members


Trusted Members

Moderators
Level 4
Forum Posts: 649
Member Since:
November 1, 2018
sp_UserOfflineSmall Offline
3
November 30, 2018 - 6:53 pm
sp_Permalink sp_Print

If you mean the password to open the file, simply open it (supplying the password) then select File - Protect Workbook, Encrypt with password and clear the password from the dialog box, then save the file.

Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
4
December 1, 2018 - 12:23 pm
sp_Permalink sp_Print

Another method is press F12 and under Tools-General Options remove the password and press OK

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Louis Muti
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Blair Gallagher
Brandi Taylor
Hafiz Ihsan Qadir
Gontran Bage
adolfo casanova
Annestine Johnpulle
Priscila Campbell
Jeff Mikles
Aaron Butler
Maurice Petterlin
Forum Stats:
Groups: 3
Forums: 24
Topics: 6369
Posts: 27852

 

Member Stats:
Guest Posters: 49
Members: 32359
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen