Excel Protected Workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-3389355%22%20slang%3D%22en-US%22%3EExcel%20Protected%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3389355%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20file%20which%20I%20been%20using%20since%20last%20year.%20I%20have%20a%20few%20sheets%20that%20I%20keep%20hidden%20so%20other%20users%20don't%20have%20access%20to%20them.%20To%20add%20more%20protection%20I%20protect%20the%20workbook%20structure%2C%20and%20I%20have%20not%20had%20any%20issues%20until%20now.%20Every%20time%20I%20protect%20it%2C%20it%20only%20last%20like%20one%20hour%20before%20it%20unprotects%20itself.%20I%20been%20protecting%20it%20saving%20and%20closing%20it%20out%2C%20and%20later%20on%20when%20I%20reopen%20it%20the%20workbook%20is%20unprotected.%20I%20notice%20the%20issue%20started%20when%20I%20started%20using%20PowerPivot%2C%20but%20I'm%20not%20sure%20if%20that%20is%20related.%20I%20need%20help%20figuring%20out%20how%20to%20keep%20the%20workbook%20protected%2C%20as%20I%20have%20many%20users%20using%20it%20and%20I%20want%20to%20prevent%20them%20from%20changing%20anything%20or%20opening%20any%20sheet%20that%20is%20not%20needed%20by%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3389355%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3391363%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Protected%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3391363%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392864%22%20target%3D%22_blank%22%3E%40Hilda_Munoz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20may%20recommend%20you%2C%20attach%20a%20file%20(without%20sensitive%20data)%20or%20a%20photo%2C%20inform%20about%20the%20Excel%20version%2C%20operating%20system%20and%20storage%20medium.%20This%20way%20you%20can%20get%20a%20solution%20proposal%20much%20faster.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20afar%2C%20I%20cannot%20understand%20how%20the%20workbook%2Fsheets%20were%20locked%20with%20the%20previous%20information.%3CBR%20%2F%3EThink%20that%20here%20it%20is%20appropriate%20to%20send%20the%20workbook%20as%20long%20as%20it%20does%20not%20contain%20any%20sensitive%20data.%3C%2FP%3E%3CDIV%20class%3D%22%22%3E(Drag%20and%20drop%20here%20or%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Freplypage%2Fboard-id%2FExcelGeneral%2Fmessage-id%2F146811%23%22%20target%3D%22_blank%22%3Ebrowse%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efiles%20to%20attach%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EMaximum%20size%3A%2071%20MB%20%E2%80%A2%20Maximum%20attachments%20allowed%3A%205)%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

I have an excel file which I been using since last year. I have a few sheets that I keep hidden so other users don't have access to them. To add more protection I protect the workbook structure, and I have not had any issues until now. Every time I protect it, it only last like one hour before it unprotects itself. I been protecting it saving and closing it out, and later on when I reopen it the workbook is unprotected. I notice the issue started when I started using PowerPivot, but I'm not sure if that is related. I need help figuring out how to keep the workbook protected, as I have many users using it and I want to prevent them from changing anything or opening any sheet that is not needed by them.

1 Reply

@Hilda_Munoz 

If I may recommend you, attach a file (without sensitive data) or a photo, inform about the Excel version, operating system and storage medium. This way you can get a solution proposal much faster.

 

From afar, I cannot understand how the workbook/sheets were locked with the previous information.
Think that here it is appropriate to send the workbook as long as it does not contain any sensitive data.

(Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5)
 
 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)