Ways to Reduce Excel File Size Remove unnecessary worksheets, data, and formulas. The number of worksheets and the amount of data contained in an Excel file are directly related to the size of the file. ... Remove formatting. ... Remove Pivot Cache. ... Save in binary format (. ... Compress the file. May 3, 2021