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.