My Excel workbook is enormous and takes too long to save, open, and close. I have followed every suggestion online for eliminating empty cells, columns, and rows and it gets bigger every time. I even saved it in binary format and it's still too big. I don't know how to shrink the size to reflect the actual amount of data in there. There are very few formulas and no pivot tables. I can't attach the file because it's over 20 MB!
Solved by K. B. in 22 mins