Share via

Slow performing Excel with conditional formatting

Anonymous
2017-03-22T18:36:33+00:00

i have conditional formatting applied to my sheet of Data. it has made Excel very slow. after i enter something, i have to wait long till excel (stops spinning) allows me to enter another value.

Conditional formatting has colors respective to value in one cell. colors are helpful as using filters is time taking in my case.

Anyway that Excel performs quickly & smoothly with conditional formatting on ?

Thanks

Shaher

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-03-23T09:51:28+00:00

    Hi Shaher,

    When your Excel file contains a large amount of data, it will really take time to load even if conditional formatting is turned off. We can start troubleshooting the issue by opening your Excel file in safe mode. This will help us identify if the issue is caused by add-ins. To start Excel in safe mode, refer to the article below:

    Open Office apps in safe mode on a Windows PC

    Let us know how it goes.

    Was this answer helpful?

    0 comments