Is there a way to stop the check performance pop-up?

Anonymous
2024-05-11T14:13:02+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments No comments

54 answers

Sort by: Oldest
  1. Anonymous
    2025-01-06T18:09:13+00:00

    Hi, Thank you. Yes it does seem to be file specific. All the best, Tony.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2025-01-06T21:33:43+00:00

    May work for some but no files that I have tried. But thanks for the info.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2025-01-06T22:20:10+00:00

    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.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2025-01-07T20:47:20+00:00

    Thanks for trying but it didn't work for me. Moon's phase? Not holding my mouth right? Only the Shadow knows...

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2025-01-13T19:19:37+00:00

    I just tried this and, unfortunately, it did not work for me.

    Was this answer helpful?

    0 comments No comments