• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

File Size Issues

J

J G

Member
The workbook I describe below is a template budget that the HQ sends out to local companies.

This macro enabled workbook that is quite large, 19 MB. When I zip the file is only shrinks to 17 MB. In order to be able to email the file I re-worked the file, got the size down to 10 MB. When I zip this file is only shrinks to 9 MB.

Why am not saving more space?

When this template is returned filled out it is about 12 MB, when zipped 6 MB. When returned it is still macro enabled.

Any thoughts?
 
Hi, J G!
If the original file, once downloaded and saved in a local machine as the same file type still has 19Mb, well, it weights 19Mb.
Then try opening that saved file and saving it as .xlsb and compare the sizes, it'd be smaller.
Now if when returned filled it weigths 12Mb, nothing can be said without analyzing the file and its macros.
The solution however maybe uploading it to DropBox (DB has corporate accounts, if any IT policy issues) and distribute the link by mail.
Regards!
 
Thanks for your response. What type of information will be lost if I converted it to xlsb? I resaved as xlsb and everything seems in order, new unzipped file size is 5MB.
 
For small files size you would use the standard file formats when saving. But for large files the xlsb save format is better, nothing is lost.
Excel Binary Workbook files store information in binary format instead of the XML format like with most other Excel files. Since XLSB files are binary, they can be read from and written to much faster, making them extremely useful for very large spreadsheets.
 
The only real disadvantage is going to be compatibility in using the data with software that wants XML instead of binary (web server for instance). If you link a lot of systems together, this may cause a problem with one of the layers, as XML was developed specifically for this purpose.
Click to expand...

The above from the link SirJB7 posted.
I have never had an issue with file size, I think many are due to weak OS/System resources..................but if the files size is an issue could you not binary it for working/sharing and when done if a web upload is needed save as normal and then upload or use in other software?
 
Thanks for the reference. We do not link this file directly to any application, web or otherwise. I think this is a good solution for us.
Thanks so much for your help.
 
Hi, J G!
Hope you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!
 
You must log in or register to reply here.
Back
Top