How to stop Excel from automatically checking Workbook performance?

Question

Performance check??

The Excel sheet is the way I want it to look and don't want to change it for better performance. I just want Excel to stop prompting me.

Every time I open an Excel sheet, it wants me to do a performance check because of:

"Excess formatting and unneeded metadata cause large, slow workbooks. Check for improvements to performance"

So I find myself X-clicking away this message every time. Because there is no 'excess' of formatting. The Excel sheet simply is a nicely layouted workbook and we want it to be looking this way. We don't need Excel trying to outsmart us and giving this suggestion every time you open the workbook to remove information.

It is only very confusing for not-very-experienced users who also make use of my Excel sheet.

How and where can I set Excel in a way that is stops asking this unwanted question?

• The question mostly pops-up in the Web version of Office 365.
• I tried unchecking boxes in the performance check tool, in the desktop version, but to no result.

Would be lovely if someone has a workaround or knows which box needs to be un-checked.

And it would be awesome if a MS engineer helps giving priority to this problem, so that it can be switched of universally.

Answer 1

This thread shows that there are a significant number of people complaining about this. Unfortunately, this is only a user forum, we understand your problem, but we cannot do anything to fix it. Only the Excel developers can do this if they are instructed to do so.

As previously stated, this is simply a statistical problem, Microsoft must first recognize that this is a problem. Unfortunately, this is not so easy considering that more than 200,000 people work at Microsoft.

There is a feedback portal where you can cast your vote. There is already a feed on this topic, unfortunately with very few votes. I'm sure if we get as many votes as this post has been viewed, then Microsoft will react.

Anyone reading this, please follow these steps:

Click on this link:
https://feedbackportal.microsoft.com/feedback/idea/89bb523d-b197-ef11-95f6-0022484d7a88

1. Sign in
2. Click the Vote button

@HanzieV:

If you mark this reply as answer, it will be the first to appear when someone views this thread. I hope we can encourage as many people as possible to draw Microsoft's attention to this problem. Unfortunately, this is all we can do for you.

Andreas.

Answer 2

are you understand what we looking for??????

We DO NOT WANT to optimize the tables, because we made it in a way we like it, even if your Excel AI do not understand it.

But it seems not even you!

CAN WE DISABLE it or no????????????

Answer 3

And so, we believe most users suffer from performance pain due to Unintentional excessive formatted cells with no data and would benefit from the notification to enhance their productivity. At the same time, we agree that users with Intentional excessive formatted cells with no data need control over the notification with a setting, and we are actively working on releasing this setting soon. We plan to monitor the setting’s usage to determine if future adjustments are needed as well.

 

We apologize again for the delay. And your feedback and patience are greatly appreciated.

 

Thank you,

Prash

I cannot believe that MOST users suffer unacceptable performance pain. I accept that many could get better performance from not formatting some cells - but that is a different thing altogether.

I contend that there are a lot of spreadsheet USERS who simply operate a spreadsheet developed for them by an expert user. Many in his category of users may have very limited Excel skills. In the case of users of some of my workbooks they simply enter a few figures ( in cells pre-formatted to indicate they can be updated) and press a few buttons. These users should NEVER be given the opportunity to change the formatting which I have spent many hours refining to give the best user experience I can provide. I have put a lot of effort into the trade off between performance and user experience. It is a conscious decision and allowing a novice user to change this is undermining my professionalism. WE MUST HAVE A WAY TO DISABLE THE FEATURE.

Answer 4

Even if the feature is used, I wonder how many users wish there was an "undo" feature available after it. Especially if that user saves the changes without realising that they've destroyed the spreadsheet. Monitoring the usage is potentially flawed logic too, if people use it not really understanding what it's going to do!

I have kept multiple backups in different locations for all the spreadsheets I've create or modified for years. I will not be changing that habit any time soon.

Answer 5

"And so, we believe most users suffer from performance pain due to Unintentional excessive formatted cells with no data and would benefit from the notification to enhance their productivity. At the same time, we agree that users with Intentional excessive formatted cells with no data need control over the notification with a setting, and we are actively working on releasing this setting soon. We plan to monitor the setting’s usage to determine if future adjustments are needed as well.

We apologize again for the delay. And your feedback and patience are greatly appreciated.

Thank you,

Prash"

In other words, the Microsoft echelon believes it's users are the dumbest of the dumb and figured Every. Single. User. would LOVE this function because they didn't know what they were doing and needed guidance from the echelon.

Instead, the echelon should realize that some Excel customers have been using it for decades, and don't just program it but also actively use it so know it inside and out, and have the same knowledge as the developers except without the ability to program it to make it better (instead of making it worse like the Microsoft developers do).