Tips to reduce the Size of the Excel File

1. Using of the same file again and again: For example: Working on the weekly Report and instead of creating a new report. We use the same report and only alter the data as per the current week and save it. This will increase the internal memory and will increase the excel file size

Solution: Keep a Blank Template and paste the data in the blank Template and not in the prior weeks report. This will help maintain the excel size

2. Sharing of Excel workbook and saving it only after a long interval also increases the excel memory and than inturn increases the size of excel

Solution: Save the file frequently, Ensure the Workbook is closed and if there is no requirement to share the file forever. Then unshare the file and save it.

3.Here are few more methods to resolve this

a.Delete un-necessary empty sheet(s). 
b. Delete un-hide sheet(s). 
c.Delete the un-used transparent data cells which doesnt have a data however these cells has been  formatted.Unwanted formatting in cells also leads to increase of the file size. 
d. Formula's and links in the excel sheet also increases the size of the file. If formula and links are not required. Remove it and save the file which contains only text.
e. Reduce the size of graphics as they take lot of space in Excel, Remove unnecessary comments, cell shading, header footer, hyperlink as they take up additional space.

f.One more point contributed in the excel mania fb page: Save the files in .xlsb format. It will reduce the file size by 50% compared to .xlsx

Happy Learning- Excel Mania:)