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

It could be some format on entire row or column. Have you tried optimizing it? It will remove all the useless format and also remove that annoy notification.

Answer 3

We don't want to optimize it, it's a input section that has unused cells we want. There is just no way to tell the program to stop checking those locations in spreadsheet or stop checking entirely. So the pop-up keeps intruding on everyone even though everything is working fine.

Answer 4

Seriously! I can't believe there's not a way to disable the incredibly annoying notifications about this.

And in our case, we've actually even gone ahead with the optimizing recommended... but it STILL shows up again the next day! Ugh! (Possibily due to having some pivot tables that filter out data as projects are added or completed, and are therefore always increasing or decreasing in size. But none of this actually affects the spreadsheet's performance, so we just want Excel for the web to start freaking bothering us with this useless notification every dang day!)
Sincerely,
A very frustrated and annoyed user

Answer 5

I totally agree. I have a spreadsheet setup for the whole year . There are many empty cells that will continue to fill as time goes by. No one needs to see the spreadsheet as it is exactly the way I want it and the same way I've done it for years. All I need is information on how to turn check performance off. The answers, to this point, just tell me there is actually no way to turn off check performance so the help team is deflecting by asking the same question just worded slightly differently. We know we could optimize. We don't want that. We just want the constant notification to go away. Is there a way to make this happen?