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

Hello, This document is downloaded each time from a website for each client that comes in, so this same document (that cannot be modified) recieves this 30+ times a day and needs closed each time. message is:

"SLOW WORKBOOK? 54% of your workbook has unused formatting and metadata that can be optimized to improve performance."
I need to not have to close this windowd 30+ times a day while opening this same document. Thanks!

Answer 3

@ ANYONE at Microsoft:

Can you please address this issue? There is a reason AI is not all it's cracked up to be. People need to be able to choose - kind of part of the humanity in us. People ask me all the time why I choose Microsoft over Apple. It is because Microsoft has always been something that I can adjust to me. I haven't had to adjust to it. Don't become Apple, because then I will go back to pen and paper.

It really is that simple.

Don't chase away those who actually understand the process in order to please a very small percentage of your users.

Answer 4

Yes. I feel like I am being punished by MS for writing code then enables removing and adding to my sheets without fumbling through the GUI. I am still trying to find a way to kill that useless message (my sheets are OK.) BTW: my sheets are super fast.

Answer 5

Dear all,

Thank you for your feedback and details. It is much appreciated.

Please correct me if I am wrong, but for workbooks that are local or on a network share and intentionally prepared with many empty formatted cells, our previous solution to suppress the notification upon first dismiss (click "X") seems inadequate because:

• When you share these workbooks with others, they also need to dismiss (click "X") the first time they open the workbook locally.
• When you download them locally and create new workbooks from them, you need to dismiss (click "X") the notification the first time you open each new workbook.
• And there may be other similar scenarios involving local sharing or reuse of these workbooks wherein such repeated dismissals aren’t productive.

Sorry for the inconvenience this has caused. To alleviate this, we are working on providing a setting to suppress the notification for the local Excel desktop and will provide more details as we approach release.

Please let me know if I’ve still missed anything.

thanx,

Prash