Make your workbooks more performant with Check Performance in Excel for Windows

Copper Contributor

Hi Microsoft 365 Insiders,

 

We’re thrilled to announce that the Check Performance feature, first introduced in Excel for the web last September, has arrived for Excel for Windows! Enhance your workbook efficiency by eliminating unneeded formatting and metadata from empty cells. Not only does this optimize your data management, but it also significantly reduces workbook size—essential for those hefty files!

 

A big shout-out to Prash Shirolkar, the product manager behind this great feature. Thank you, Prash, for making Excel more performant and user-friendly! :clapping_hands::clapping_hands: 

 

Check out how this feature streamlines your workflow and speeds up performance: Make your workbooks more performant with Check Performance in Excel for Windows  

 

Thanks!

 

Perry Sjogren

Microsoft 365 Insider Social Media Manager

 

Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android

2 Replies
Spoiler
 

@PerrySjogren 

Hi. There are plenty of claims around this feature.

How to stop Excel from automatically checking Workbook performance? - Microsoft Community

I want to disable Excel 365 performance improvement auto-nags - Microsoft Community

Prash is aware since March 2023 about this terrible mess caused by such feature.

His last reply 3rd Jan 2024 is the following:

Thank you for your feedback folks! Please rest assured that your feedback has been relayed to the Check Performance feature team. And apologies for the delay, however, a reliable solution to this has been more complicated than originally thought and so it has taken more time. Check Performance feature team is actively working on it and we’ll update you when the solution is closer to being ready for release.

 

We truly need such feature with an option to disable it.

Regards. S

@PerrySjogren 

 

I have a problem with #CheckPerformance

My spreadsheet is designed to be used by users with limited Excel knowledge. So, I have used VBA to hide things the user should not see (e.g. ribbon menu, borders). The interface for the user is stripped back to a blank background with a very limited amount of data and a series of buttons to take available options.

I have attached a screenshot.

Now when the user opens the spreadsheet if displays a message about checking performance. This is confusing to my users.

The option to check for performance is useful, but it should be restricted to an option on the ribbon. Automatic running of the code is entirely useless and confusing to my users. This looks like the developer assumes that anyone who opens the workbook is an an experienced user with permission to change the workbook. This is not true for my users.

If I could cancel the message in VBA as part of the OnOpen code that would be acceptable. However, it should never have been implemented in this way.

 

MartynRK_1-1718811152757.png