How to open a .zip file which is embedded in .xlsx file?
I have a .zip file which has been embedded in a .xlsx file (excel ). But everytime I double click on the file it keeps giving this message:
Cannot start source application for this object. There may not be enough space in memory.
How can I open the .zip file? I have downloaded the unarchiver and also OpenXMLConvertor.But I dont know how to use them to extract the file.
I have Microsoft Excel 2011 (Version 14.0.0) and MAC OS X mountain lion, 64 bit , macbook air (2013). Kindly help
The thing is - all Microsoft Office documents are ZIP files containing XML files. I would try this:
- copy the XLSX to another location
- Rename the copy by addin ".zip" to it (ignore the warnings)
- unzip the copy with your favourite tool (Unarchiver or terminal "unzip ")
- look through the folder structure and find your zip file.
I followed the answer from VISHAL DAGA above, with some minor variations.
- Change the .xlsx to .zip
- In terminal, run
unzip {{file}}
- In the resulting folder, change your directory to xl/embeddings
- In that folder, there should be .bin files. Run
unzip {{ file }}.bin
- Profit! The file should now be accessible in its proper, unzipped form.