When I download an excel 2007 file, such as xmls, from our web server, it saves the file as a zip file which, when opened with WINZIP, has several files inside. How do I open the file as the excel worksheet that it was before the download?
No. Excel 2007 divides the file into several pieces for compatibility. That much I know. Unfortunately, when downloading from some servers, the files are put individually into a zip file. None will open the worksheet and I don't know how to put them back together.
_rels
docProps
xl
[Content_Types]
When you try to open any of them, all you get is a web page similar to:
Formally Excel 2007 file is a zip archive.
Therefore after downloading just rename ZIP filename extension to XLSM one.
And you can load such renamed file into Excel.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.