Forum Discussion

PerrySjogren's avatar
PerrySjogren
Copper Contributor
Apr 03, 2024

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

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 wor...
excel
Microsoft 365 Insider
MartynRK's avatar
MartynRK
Copper Contributor
Jun 19, 2024

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.

 

 

 

Resources