SharePoint Migration Tool - XLS Password Protected

%3CLINGO-SUB%20id%3D%22lingo-sub-1360497%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Migration%20Tool%20-%20XLS%20Password%20Protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1360497%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169722%22%20target%3D%22_blank%22%3E%40Dale%20Howard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20always%20using%20the%20password-protected%20Excel%20files%20in%20SharePoint%20without%20any%20issues%2C%20I%20have%20migrated%20many%20files%20with%20SPMT%20no%20issues%2C%20check%20the%20link%20below%20also%20try%20to%20sync%20the%20document%20library%20and%20open%20it%20from%20your%20computer%20and%20see%20if%20there%20is%20any%20difference%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fsaving-password-protected-documents-to-sharepoint%2F360fbd39-eb12-4809-9e28-99a0bf73663e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fsaving-password-protected-documents-to-sharepoint%2F360fbd39-eb12-4809-9e28-99a0bf73663e%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1360536%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Migration%20Tool%20-%20XLS%20Password%20Protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1360536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70455%22%20target%3D%22_blank%22%3E%40Alireza%20Rahimifarid%3C%2FA%3E%26nbsp%3BThank%20you%2C%20but%20this%20is%20the%20first%20time%20we%20have%20uploaded%20these%20files%20to%20Sharepoint%20using%20SPMT.%20All%20files%20in%20question%20appear%20to%20be%20password%20protected.%20We%20have%20no%20reason%20to%20believe%20they%20were%20password%20protected%20in%20the%20first%20place.%20When%20we%20download%20the%20files%20to%20the%20desktop%20using%20browser%20download%20they%20open%20perfectly%20fine%20without%20any%20password%20prompt.%20The%20password%20error%20only%20appears%20when%20opening%20the%20file%20within%20the%20browser.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1361016%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Migration%20Tool%20-%20XLS%20Password%20Protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361016%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169722%22%20target%3D%22_blank%22%3E%40Dale%20Howard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20these%20files%20xlsx%3F%20can%20you%20please%20attach%20the%20screenshot%20of%20the%20error%20message%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1362584%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Migration%20Tool%20-%20XLS%20Password%20Protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1362584%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70455%22%20target%3D%22_blank%22%3E%40Alireza%20Rahimifarid%3C%2FA%3E%26nbsp%3BPlease%20find%20attached.%20I%20have%20done%20some%20more%20testing%20now%20and%20found%20that%20I%20can%20open%20the%20files%20perfectly%20fine%20through%20the%20iOS%20sharepoint%20app.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1360102%22%20slang%3D%22en-US%22%3ESharePoint%20Migration%20Tool%20-%20XLS%20Password%20Protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1360102%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20recently%20begun%20migrating%20some%20data%20to%20SharePoint%20Online%20using%20the%20SharePoint%20Migration%20Tool.%20We%20are%20doing%20this%20slowly%2C%20but%20we%20have%20noticed%20that%20some%20XLS%20originally%20from%202008%20present%20themselves%20in%20SharePoint%20as%20being%20Password%20Protected.%20This%20means%20that%20clicking%20on%20the%20File%20in%20SharePoint%20in%20Office%20365%20presents%20an%20error%20declaring%26nbsp%3B%3CEM%3E%22We%20couldn't%20open%20this%20workbook%20because%20it's%20protected%20with%20a%20password.%22%3C%2FEM%3E%3C%2FP%3E%3CP%3EDownloading%20the%20file%20and%20opening%20instead%20works%20perfectly%20fine.%20This%20is%20our%20first%20attempt%20into%20SharePoint%20Migration%20and%20like%20to%20get%20this%20correct%20before%20releasing%20crib%20sheets%20to%20our%20users.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1360102%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

We have recently begun migrating some data to SharePoint Online using the SharePoint Migration Tool. We are doing this slowly, but we have noticed that some XLS originally from 2008 present themselves in SharePoint as being Password Protected. This means that clicking on the File in SharePoint in Office 365 presents an error declaring "We couldn't open this workbook because it's protected with a password."

Downloading the file and opening instead works perfectly fine. This is our first attempt into SharePoint Migration and like to get this correct before releasing crib sheets to our users. 

4 Replies
Highlighted

Hello @Dale Howard 

We are always using the password-protected Excel files in SharePoint without any issues, I have migrated many files with SPMT no issues, check the link below also try to sync the document library and open it from your computer and see if there is any difference?

https://answers.microsoft.com/en-us/msoffice/forum/all/saving-password-protected-documents-to-sharep...

 

 

Highlighted

@Alireza Rahimifarid Thank you, but this is the first time we have uploaded these files to Sharepoint using SPMT. All files in question appear to be password protected. We have no reason to believe they were password protected in the first place. When we download the files to the desktop using browser download they open perfectly fine without any password prompt. The password error only appears when opening the file within the browser.

Highlighted

@Dale Howard 

Are these files xlsx? can you please attach the screenshot of the error message?

 

Highlighted

@Alireza Rahimifarid Please find attached. I have done some more testing now and found that I can open the files perfectly fine through the iOS sharepoint app.