Did you ever have problems sending excel files of several MBs through your email systems?? Sometimes it rejects it because it exceeds the quota size or takes forever to send…….This article shows how to split huge excel files into smaller parts which can easily be sent.Plus, it explains how to put them back together.
Sometimes our email systems limit the size of the attachment, suppose the maximum allowable limit is set at 1.5 MB and you have got an excel file that exceeds this size limit then to overcome this problem, you can split your excel file into smaller parts using winzip’s split feature.
To split a file you got to zip it first. Say, you have an excel file of 15 MB. Now, when you Zip it, the zipped file is only about 3 MB. But even that exceeds our limit of 1.5 MB. Now to split it into smaller segments open it with winzip.
Choose Split from the Actions menu.
Give it any name but not the same as the zipped file name.
Now from the part-size drop-down menu, select the size you need for the individual parts. You can also specify your own size. To do that, Just choose “Other size” in the drop-down list and type in the required size in the Other size field.
Press OK to create the split Zip file.
You will notice that it has created files with extension like .Z01, .Z02 etc. and one .zip file.
To open the split Excel Zip file, simply keep all the files( .01 type files and .zip file) in the same folder. And then, just open the file with the .zip extension.
Share ThisPopularity: 18%