An .xlsx or An .xlsm is a zip file. Thus, in order to determine what occupies the most size in an Excel file, it might be copied and renamed with the extension.zip. The sheet that uses the most space is then easiliy found.
Of course, how to remove data is a different story altogether.
