This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a spreadsheet that I use daily that just started getting the stupid "Slow workbook? 50% of your workbook has unused formatting and metadata that can be optimized to improve performance...Check Performance" pop-up that I'm having to close out every time I open the workbook. It's super annyoying because the spreadsheet is formatted just the way I need it and the stuff "excel" wants to remove is stuff that I don't want removed. How can I make the popup stop? I've looked through the options and googled but can't seem to find a straight forward answer. Hoping someone has some kind of trick to make it stop.
The main issue seems to be that I have every other column formatted like pictured below. I did this so that I could easily see each column of data to make sure I was working in the correct one. Is there a easier way to do that?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
It is currently not possible to disable this feature, but Microsoft is working on it. It turned out to be more complicated than originally estimated, so the fix has been delayed.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
I doubt its that difficult to turn off a popup. If it is that difficult then the coders have done a trash job setting up the workflow. I with literally no real experience in coding can setup check boxes. This is an abysmal failure for which someone needs to be reprimanded.
FYI this isn't a new issue.
it is also here
and here
and here
Any updates on the fix? I noticed this first appeared when changed my setup to have some formulas read data from its' own cell.
Now I am finding it's on my other workbooks as well and I don't even know why...but I rather it not be micro-managing my workbooks unless I ask for it to, because that pop-up is a waste of time in itself to have x click off everytime.
Exactly! It's ironic that a "performance check" which is designed to supposedly enhance performance of a workbook actually decreases a user's ability to perform.