Corrupted Spreadsheet After Password Enabled

%3CLINGO-SUB%20id%3D%22lingo-sub-2023830%22%20slang%3D%22en-US%22%3ECorrupted%20Spreadsheet%20After%20Password%20Enabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2023830%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20that%20has%20about%2014%20Tabs%20with%20many%20formulas.%20I%20currently%20have%20all%20tabs%20Unprotected%2C%20but%20would%20like%20to%20invoke%20a%20password%20on%20this%20spreadsheet.%20When%20I%20enable%20a%20password%20on%20this%20spreadsheet%2C%20Excel%20renders%20the%20spreadsheet%20corrupted.%20I%20cannot%20open%20the%20file%20after%20an%20encrypted%20password%20has%20been%20enabled.%3C%2FP%3E%3CP%3EI%20am%20using%20Windows%2010%20and%20Office%20365%20and%20the%20file%20is%20saved%20on%20my%20hard%20drive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20file%20is%20save%20as%20a%20xlsx%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2023830%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a workbook that has about 14 Tabs with many formulas. I currently have all tabs Unprotected, but would like to invoke a password on this spreadsheet. When I enable a password on this spreadsheet, Excel renders the spreadsheet corrupted. I cannot open the file after an encrypted password has been enabled.

I am using Windows 10 and Office 365 and the file is saved on my hard drive.

 

The file is save as a xlsx format.

0 Replies