Excel New Check Performance To Reduce Excel File Size - Episode 2632

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 metadata that can slow down your workbook. While it may be tempting to get rid of everything, it's important to be cautious as there may be some formatting that you actually want to keep. For example, if you have a tooltip cell or if you're using pixel art, Check Performance may not be able to detect it and could potentially delete it. However, the good news is that the undo button can bring back any unintentionally deleted formatting.
In this video, we'll also be discussing a potential issue with Check Performance that was discovered while filming. It seems that in some cases, the feature may not work perfectly and could potentially delete intentional formatting. So, while it can be a useful tool for cleaning up excess styles and formats, it's important to be careful and double check before using it. As always, if you have any questions or comments, please feel free to leave them down below and don't forget to like, subscribe, and ring the bell for more helpful Excel tips and tricks. Thank you for watching and we'll see you in the next episode of MrExcel's Net Cast!
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-...
To download the workbook from today: www.mrexcel.com/youtube/a338W...
Table of Contents
(00:00) Check Performance debuts in Excel
(00:13) On the Review tab
(00:23) Excess formatting, cell styles, and metadata that can slow your workbook down
(00:48) Identifies useful cells that appear blank
(01:06) Do not use with pixel art
(01:20) Undo works
(01:36) Row Height is there on purpose
(02:04) Undo after Row Height left images in wrong spot
(02:20) Useful but be careful
(02:30) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelnew #excelperformance
This video answers these common search terms:
how to improve performance on excel
excel is slow how to fix
how to fix a slow excel
how to fix excel slowness
how to get rid of excess formats in excel
Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads...

[@spilledgraphics]

Merry Christmas! Thank you Excel Team !!!

[@spilledgraphics]

And you Bill, for posting about it!

[@drsteele4749]

It's still November! Americans haven't even had Thanksgiving yet, and Advent begins Dec3, so wait a bit, ya?

[@johnborg5419]

Thanks Mr Excel!!! :) :)

[@mathew9665]

Nice update infromation, thank you - odd that Microsoft does not run this like the Power BI update vidoes

[@DimEarly]

I had the same reaction, especially to the way it sees a row height on an empty row as ‘bloat’ - I sometimes see it as important to make things line up! But worth taking a look at…

[@MrXL]

I think my feedback to the Excel team is to consider a rule along the lines of "increased row height, even in a blank row, with additional text or objects below, should not be considered bloat."

[@DimEarly]

@@MrXL I agree, that seems like a sensible rule 👍

[@ricos1497]

​@@MrXL and, perhaps, not within the print range? On extremely rare occasions, I've narrowed a row in order to optimise for printing (usually there was a footer involved).

[@erick222]

How do you enable this feature? A workmate has it under Review and he has the same version and build number but I don't have it. Also drilled into Customize Ribbon as well and it is not available.

[@user-fp3mo4fw2z]

Hello sir you same help me??

[@user-fp3mo4fw2z]

Sir i buy luck number Random app