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: Most helpful
  1. Anonymous
    2025-07-03T19:40:52+00:00

    Job well done, Alan! As Leigh Ann said, it's validating to have this information, and certainly reflects what I've read about the issue.

    Are you paying attention, Microsoft?!

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2025-07-02T17:04:24+00:00

    That is one fantastic use of Chat GPT, Alan... Thank you!! I feel so validated and I'm sure others on this thread will too. I am terrified that someone who doesn't know what they are doing will try to "FIX" one of my spreadsheets and completely ruin it. Clearly Microsoft doesn't care about that, which makes me wonder - how does it benefit them to have our spreadsheets rendered useless? How is that supposed to make us feel more positively about Excel / Microsoft and want to buy more of their products? I just don't get their end game here.... Is it just flat out laziness, or stubbornness just to spite their users, or - ???. Such baffling behavior...

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2025-07-02T08:45:13+00:00

    I think you might have hit the nail on the head here Leigh Ann. Out of interest I just tried the following Chat GPT prompt...

    "conduct a review of all online content you can find relating to Microsoft Excel's "Check Performance" feature. give a summary of the opinions expressed by users and estimate the proportion which are positive versus negative"

    Response...

    Here’s a refined overview of sentiment around Excel’s “Check Performance” feature based on what users are saying online:


    👍 Positive Views (~15–20%)

    • Useful for very large files: Independent tech reviewers note that it effectively clears “low-hanging fruit”—unnecessary formatting and metadata—from bloated workbooks, sometimes reducing file size dramatically reddit.com+15office-watch.com+15techcommunity.microsoft.com+15.
    • Useful in targeted scenarios: The feature can be beneficial when used deliberately—i.e., for truly sluggish, oversized files.

    👎 Negative Views (~80–85%)

    • Forced prompts are intrusive: Many feel the pop-ups interrupt workflow and become a nuisance when repeatedly appearing upon opening files .
    • Lack of a disable switch: A major frustration is the inability to turn off the feature. Users repeatedly request an “opt-out,” but no permanent solution is available yet .
    • Unwanted formatting removal: Users report that formatting they added intentionally gets stripped—sometimes breaking important visual cues or VBA-driven layouts reddit.com+7techcommunity.microsoft.com+7answers.microsoft.com+7.

    “This feature may be well‑meaning…but it is…taking us backward” techcommunity.microsoft.com+2techcommunity.microsoft.com+2techcommunity.microsoft.com+2


    🔧 Neutral or Mixed Opinions


    📊 Sentiment Breakdown

    • Negative: ~80–85%
      Common complaints include no opt-out, forced interruptions, unintended formatting changes, and instability.
    • Positive: ~15–20%
      Mostly among reviewers and users managing truly large, unwieldy workbooks.
    • Neutral/Mixed: ~5–10%
      Users acknowledge utility but request more nuance and control.

    🔍 Final Take

    Overall, while the underlying idea of detecting and cleaning up hidden inefficiencies is sound, the execution and rollout have frustrated many. The recurring theme: “It should be optional.” Until a proper toggle option is introduced, most users are leaning negative, with frustration centering on control and interference.

    If you're working with huge, sluggish Excel files, give it a try—but proceed with caution and back up your file first. Otherwise, be ready to manage—or simply close—the intrusive prompts.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2025-07-01T17:24:07+00:00

    It's still popping up on my spreadsheets, even today 7/1/25.

    Was this answer helpful?

    0 comments No comments