SOLVED

password protecting workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-2769197%22%20slang%3D%22en-US%22%3Epassword%20protecting%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2769197%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Etrying%20to%20password%20protect%20workbook%20but%20this%20error%20comes%20up.%20Does%20anyone%20know%20what%20it%20actually%20means%20and%20can%20tell%20me%20what%20i%20need%20to%20do%3F%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2769197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2769470%22%20slang%3D%22en-US%22%3ERe%3A%20password%20protecting%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2769470%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1019045%22%20target%3D%22_blank%22%3E%40woodgem%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%3C%2FP%3E%3CP%3EAsk%20away.%3C%2FP%3E%3CP%3EPlease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EHere%20is%20some%20information%20from%20Microsoft%20about%20IRM%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Fcannot-open-irm-protected-workbook%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EYou%20cannot%20open%20an%20IRM%20protected%20workbook%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fexchange%2Fenable-or-disable-information-rights-management-logging-exchange-2013-help%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EEnable%20or%20Disable%20Information%20Rights%20Management%20Logging%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2769502%22%20slang%3D%22en-US%22%3ERe%3A%20password%20protecting%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2769502%22%20slang%3D%22en-US%22%3EThanks%20so%20much%20for%20getting%20back%20to%20me!%20I%20can%20open%20password%20protected%20workbooks%20fine%20just%20not%20add%20the%20password%20protection%20to%20others%20and%20since%20working%20remotely%20need%20to%20be%20able%20to%20create%20new%20workbooks%20with%20password%20protection%20before%20sharing%20them.%20And%20sorry%20I%20still%20don't%20understand%20the%20IRM%20issues.%20is%20there%20a%20step%20by%20step%20process%20I%20need%20to%20go%20through%20from%20within%20excel%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2769507%22%20slang%3D%22en-US%22%3ERe%3A%20password%20protecting%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2769507%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1019045%22%20target%3D%22_blank%22%3E%40woodgem%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20i%20already%20said...%3C%2FP%3E%3CP%3EPlease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThe%20cause%20can%20be%20very%20diverse%2C%20therefore%20without%20a%20inserted%20file%20(without%20sensitive%20data)%20to%20see%20where%20the%20problem%20may%20be%2C%20it%20is%20almost%20impossible%20to%20help%20in%20any%20way.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EWithout%20knowing%20which%20excel%20version%20and%20which%20operating%20system%20it%20is%2C%20it%20is%20usually%20even%20more%20difficult.%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20time%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

 

trying to password protect workbook but this error comes up. Does anyone know what it actually means and can tell me what i need to do? Thanks!

 

7 Replies

@woodgem 

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!

Ask away.

Please include the following info to help others answer your question

Welcome to your Excel discussion space!

 

Here is some information from Microsoft about IRM

You cannot open an IRM protected workbook

Enable or Disable Information Rights Management Logging

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

Thanks so much for getting back to me! I can open password protected workbooks fine just not add the password protection to others and since working remotely need to be able to create new workbooks with password protection before sharing them. And sorry I still don't understand the IRM issues. is there a step by step process I need to go through from within excel?

@woodgem 

Like i already said...

Please include the following info to help others answer your question

Welcome to your Excel discussion space!

The cause can be very diverse, therefore without a inserted file (without sensitive data) to see where the problem may be, it is almost impossible to help in any way.

Without knowing which excel version and which operating system it is, it is usually even more difficult. 

 

Thank you for your time and patience

 

NikolinoDE

I know I don't know anything (Socrates)

windows 10 64 bit office 365
microsoft ofice professional plus 2016

any excel workbook doesn't work

Hopefully this is the info you need?
best response confirmed by woodgem (Occasional Contributor)
Solution

@woodgem 

Repair an Office application

If an Office application such as Word or Excel isn’t working correctly,

sometimes restarting it will fix the problem.

If that doesn’t work, you can try repairing it.

When you’re done, you might need to restart your computer.

Click on the upper Link for more Informations.

 

Hope I was able to help you with this info.

 

NikolinoDE

repairing it has worked. Thank you!!!!!!

@woodgem 

Nice that I was able to help you in the end.

Furthermore, I wish you much success with Excel.

 

NikolinoDE