![]() Sorry for the long description, but if anyone can shed light or suggest a fix, I'd be grateful. So all in all, it looks like the simple 'Protect Workbook' option to add/remove a password has been removed, butchered or has somehow stopped functioning properly. ![]() That document still works correctly, requiring the password to open it, but I can find no way to actually remove it if I wanted to. ![]() If they have somehow 'updated' or upgraded' my Office 2007 and removed the simple password system, then I'm not very happy about it.Īlso, I have one workbook that already has a password, which I created a few years ago. I only use Microsoft Office offline, and I do not want any online involvement form Microsoft. To set a file open password in Excel: Click File > Save As > More Options Next, in the Save As dialog box, click Tools > General Options The General Options dialog box appears. If I select the 'Restricted access' or 'Manage credentials' option, then I am offered a free trial of the Information Rights Management Service, whatever that is. ![]() But whatever I do, when I close the book and open it again, I am not being asked for the password - the workbook just opens again without asking for the password. This video shows you how to remove the password required to open workbook in MS E EASILY UNLOCK Protected Excel Sheets WITHOUT Password New 284 views 3 weeks ago Excel (A-Z) 331 views. I have tried all options, in 'Protect Sheet', Protect Workbook' Share Workbook', and 'Protect and Share Workbook', and many of them DO allow me to enter a password, and verify it by entering it again. If I create a password to protect a sheet, in order to protect cells that on an already open sheet, then everything is working as it always has.īut if I try to protect a workbook, I simply can no longer find a way to add a password that locks the workbook and prevents others from opening it. If that doesn't work for some reason, please let me what operating system and excel version you are using. zip Step 3: Drill down through the zip file folders: xl/ and select the workbook.xml file. Has anyone else found that passwords on Excel (2007) no longer work for withholding access to a workbook? Answer SU SuuuperG Independent Advisor Replied on ApReport abuse There should be a general options, then you can delete the password. To remove the password on a Read Only file: Step 1: Close the file and make a copy just in case you make a mistake Step 2: Rename the file and change the extension to.
0 Comments
Leave a Reply. |