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

54 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-09-21T15:21:05+00:00

    I am doubtful that MS is "working on it." This issue has been ongoing for years. Lots of complaints, all of them reflecting very similar circumstances (My spreadsheet is fine the way it is, I'm aware of the formatted but unused (yet) cells, it's confusing to other users, etc.) and lots of "helpful" responses (Have you tried optimizing? Can you send me your spreadsheet?) and never anything usable.

    My suspicion is that there is something useful to MS in keeping this function in place -- data gathering seems likely -- or this would have been easier to fix.

    Yours in the struggle,
    rogerpaige

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-09-17T18:11:45+00:00

    Surprised there isn't a fix by now. We don't need more pop ups reminding us of our inadequacies. Excel trying to push us to therapy.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-09-16T10:24:47+00:00

    Just adding my voice to those keen for this bug to be resolved. I have produced several large sheets shared with multiple users on Sharepoint. The formatting on the sheets is by design and the performance is fine, but every time one of my colleagues opens one of these sheets Microsoft gives them the convenient option of wiping out the formatting I have painstakingly designed. Apparently I could suppress this warning with VBA but that will just result in more warnings for the user.

    If Microsoft is able to program this "feature" they can surely easily include an option in settings to turn it on or off.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-08-29T20:08:16+00:00

    Microsoft Fix this bug! This causes my spreadsheets to be reformatted without my permission! Argh!!

    Was this answer helpful?

    0 comments
  5. Anonymous
    2024-08-22T13:11:39+00:00

    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.

    Was this answer helpful?

    0 comments