Search This Blog

Search Engine

Custom Search

20160510

How to reduce excel file size?


How to
Reduce


Size?





Method 1

Save the xls file as xlsx
File size will be reduced.



Method 2

If xlsx file is still bigger, win zip it and send
By zipping the file by Compress or Winzip software, the file size is again reduced by more bytes.



Method 3

If WinZip is again more than 5mb then save the xls or xlsx file as xslb, the file size will reduce by 70%


If the fize is saved as xlsb directly from xls or xlsx then the reduced size is lesser as compared to winzip file. i.e. Converting to xlsb file is more intelligent option rather than winzipping or compressing file

No comments: