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.
Thanks for trying but it didn't work for me. Moon's phase? Not holding my mouth right? Only the Shadow knows...
Yeah, didn't work for me either. Microsoft must like you.
You would think the simplest of fixes would be the ability to answer "NO" - I do not want to check the performance of my spreadsheet when it has been set up for this particular task for over 20 years! You could even have a second question pop up after the "NO" - "are you sure?" and when I say "YES, I'M SURE", never have that question pop up again. Or even have that pesky box to check to "never ask again". But of course, I'm sure every engineer / management personnel at Microsoft reads these. We are only insignificant morons that don't really know what we want / need. They are the geniuses providing us with their greater knowledge of how we "Should" run their program.
May work for some but no files that I have tried. But thanks for the info.
Hi, Thank you. Yes it does seem to be file specific. All the best, Tony.
After much weeping and wailing and gnashing of teeth, and much online research, I found an obscure thread in reddit, and tried what it recommended.
First, open the spreadsheet and click the "x" to cancel the "check performance" banner. Then go to the "Review" toolbar and click on the "Check Performance" button. When the side panel opens, make no changes, just exit out of the side panel. Then, immediately save the file and close it. Then go back and re-open the file.
Don't ask me why, but this seems to have worked for me... I no longer get the annoying pop-up!
Hope this helps some of you.
Addendum: After experiencing the initial success, I decided to test the "fix" from other workstations on our Local Area Network. The pop-up no longer occurs for that file, but still occurs for other files. The "fix" appears to be "file-specific" not "workstation-specific".
Addendum: I have had several people say that it worked.... one that said it did. It worked for me with two different files.... maybe it was the whole thing at the cross-roads the other night.....