Right after I change the extension to .zip, once I double click it says " unknown or damaged file" and won't let me open the zip file. What can i do? Thanks in advance
I've seen instances of that happening if the zip file is located inside a cloud storage service like OneDrive or Google drive. I would suggest not storing the file in a cloud storage service if you can. Maybe just move the Excel file over to a non-cloud storage service for the time it takes to do this process and then move the unlocked file back. If you don't happen to have it located inside your cloud storage then I would just suggest making a new copy and doing the conversion again because that can happen sometimes. It's rare but it can happen.
@@paulomalley Thanks for the quick reply. I did as you suggested and still popped up the same error. :( I'm desperate, I absolutely need these files...
Is it possible that the Excel file is not a standard password protected file and is instead encrypted with file protection such as Microsoft 365s file protection? Because if that's the case, this process is not going to be able to unlock that component of it. That sort of encryption is far more robust.
@paulomalley Nah I wouldn't have gone that far. With the excel opened I clicked file>info>protect file. Which I believe it's the first kind of protection you mentioned.
Ah, that implies that this file of yours is not actually a regular Password Protected Excel file. Your file seems to be protected by Information Rights Management which is completely separate to Password Protection in Excel. You can read more about it here - support.microsoft.com/en-au/office/restrict-access-to-workbooks-with-information-rights-management-in-excel-3525d8fd-4313-4645-b60e-5ec0e1b9c317#ID0EBBD=Windows But the short version is basically that the guide I have shown here isn't going to work for this as it is a completely different mechanism for locking the file that is not related to Excel itself.
macOS handles ZIP files very differently to Windows 10/11. So much so, that I doubt this process as it is shown would work there. macOS doesn't allow you to simply open the ZIP file and view it's contents, it instantly attempts to unzip/extract it instead.
I've seen this once or twice, but it usually only happens if the zip file is saved in OneDrive (or another cloud storage option). If your file is saved to OneDrive or similar, please try saving it to a non cloud location and try again. I believe this is because the cloud storage applications are trying to sync the file while we are trying to use it (but I don't know exactly why it causes the error).
That seems like an unusual thing to see if you followed the directions of the video. Is your file saved to a cloud location like OneDrive possibly? If so, try this process again with the file in a non cloud save location. It's rare, but I've seen some cases where having the file syncing to OneDrive can prevent you from being able to modify it.
I wouldn't go with Windows 7 for this. Windows 7's File Explorer doesn't support natively opening ZIP files like modern versions do. Windows 10 and 11 do though. And for what it is worth, I performed this whole process on Windows 11 for the video.
I've seen this occasionally if the original file is locked with Rights Management solutions. This is something different to password protection on an Excel file. I've also seen it if the Zip file is stored in a cloud storage like OneDrive or similar (this is less common).
I've seen this once or twice, but it usually only happens if the zip file is saved in OneDrive (or another cloud storage option). If your file is saved to OneDrive or similar, please try saving it to a non cloud location and try again. I believe this is because the cloud storage applications are trying to sync the file while we are trying to use it (but I don't know exactly why it causes the error).
It should be able to provided you are on Windows 10 or 11. Just make sure that the zipped file is not saved in a cloud storage location as that can sometimes cause that issue.
No. This is not a process to bypass things like EncryptionSafe or Microsoft 365 File Protection features. It is to unlock files that simply use the built in Password Protection features in Excel.
Thanks! Followed your steps exactly and it works a treat!
Hi , thank you for the video, after open the sheet1.xml i look for sheetData no , protect no , sha1 no , do you have better Idea
Right after I change the extension to .zip, once I double click it says " unknown or damaged file" and won't let me open the zip file. What can i do? Thanks in advance
I've seen instances of that happening if the zip file is located inside a cloud storage service like OneDrive or Google drive. I would suggest not storing the file in a cloud storage service if you can. Maybe just move the Excel file over to a non-cloud storage service for the time it takes to do this process and then move the unlocked file back.
If you don't happen to have it located inside your cloud storage then I would just suggest making a new copy and doing the conversion again because that can happen sometimes. It's rare but it can happen.
@@paulomalley Thanks for the quick reply. I did as you suggested and still popped up the same error. :( I'm desperate, I absolutely need these files...
Is it possible that the Excel file is not a standard password protected file and is instead encrypted with file protection such as Microsoft 365s file protection?
Because if that's the case, this process is not going to be able to unlock that component of it. That sort of encryption is far more robust.
@paulomalley Nah I wouldn't have gone that far. With the excel opened I clicked file>info>protect file. Which I believe it's the first kind of protection you mentioned.
Yeah, that's what this video guide is for.
Annoyingly though, aside from trying it again, there isn't much else you can try to get it working.
After opening the Zip file, nothing is the same as the video. There's no "xl" folder, just "EncryptionInfo" and "EncryptedPackage". Can that be fixed?
Ah, that implies that this file of yours is not actually a regular Password Protected Excel file. Your file seems to be protected by Information Rights Management which is completely separate to Password Protection in Excel. You can read more about it here - support.microsoft.com/en-au/office/restrict-access-to-workbooks-with-information-rights-management-in-excel-3525d8fd-4313-4645-b60e-5ec0e1b9c317#ID0EBBD=Windows
But the short version is basically that the guide I have shown here isn't going to work for this as it is a completely different mechanism for locking the file that is not related to Excel itself.
please check the file , if it .xls to zip - dont work, convert file from xls to xlsx, then follow the process, it works thank you
Works Fine,.. Thanks Buddy
I tried to follow your method on my Mac laptop, but I could not open it. It says, "unable to expand the file. It is in unsupported format!"
macOS handles ZIP files very differently to Windows 10/11. So much so, that I doubt this process as it is shown would work there. macOS doesn't allow you to simply open the ZIP file and view it's contents, it instantly attempts to unzip/extract it instead.
Hi, I tried this, I am keep geetin an error " Windows cannot open the folder. The Compressed folder is invalid."
I've seen this once or twice, but it usually only happens if the zip file is saved in OneDrive (or another cloud storage option).
If your file is saved to OneDrive or similar, please try saving it to a non cloud location and try again.
I believe this is because the cloud storage applications are trying to sync the file while we are trying to use it (but I don't know exactly why it causes the error).
This doesn't work for me. After zipping the Excel file I'm unable to open the zip. "Windows cannot open this folder" apparently it's invalid
That seems like an unusual thing to see if you followed the directions of the video.
Is your file saved to a cloud location like OneDrive possibly? If so, try this process again with the file in a non cloud save location.
It's rare, but I've seen some cases where having the file syncing to OneDrive can prevent you from being able to modify it.
@@paulomalley Nah, one drive isn’t on. I’m downloading windows 7 onto a VM to see if it’s a windows 11 thing
I wouldn't go with Windows 7 for this. Windows 7's File Explorer doesn't support natively opening ZIP files like modern versions do.
Windows 10 and 11 do though. And for what it is worth, I performed this whole process on Windows 11 for the video.
Hello, after copy new file in old, there is this code from zip : access denied.
I've seen this occasionally if the original file is locked with Rights Management solutions. This is something different to password protection on an Excel file.
I've also seen it if the Zip file is stored in a cloud storage like OneDrive or similar (this is less common).
I couldn't open the file. It says Windows cannot open the folder: The compressed (zipped) folder......copia.zip is invalid
I've seen this once or twice, but it usually only happens if the zip file is saved in OneDrive (or another cloud storage option).
If your file is saved to OneDrive or similar, please try saving it to a non cloud location and try again.
I believe this is because the cloud storage applications are trying to sync the file while we are trying to use it (but I don't know exactly why it causes the error).
Unfortunately Winnows cannot open the zipped file
It should be able to provided you are on Windows 10 or 11. Just make sure that the zipped file is not saved in a cloud storage location as that can sometimes cause that issue.
Very bad idea,, not working 😕😕
How so? If you can provide me with some information about how it is not working, I might be able to help.
As you can see in the video, it does work.
For me it doesn't work as when i rename it to .zip it won't let me open it
Mine is .xls
Will an excel file locked with EncryptionSafe be unlocked, hope not ??!!
No. This is not a process to bypass things like EncryptionSafe or Microsoft 365 File Protection features.
It is to unlock files that simply use the built in Password Protection features in Excel.