Microsoft Excel Tutorial: A new Check Performance Feature debuts in Excel to clean excess cell formatting that can cause large file sizes.
Welcome to episode 2632 of MrExcel's Net Cast! In this video, we'll be discussing a new feature in the Windows version of Excel that has been available in Excel online for some time now. It's called Check Performance and it can help you clean up unwanted cell formats and reduce file sizes. This feature can be found on the Review tab and is definitely worth checking out for any workbook that you've been using for years.
Now, before you go ahead and click "optimize all", it's important to take a look at what Check Performance has found. It looks for excess formatting, unused cell styles, and unneeded...