Forum Discussion
Excel - certain formatting slow on Mac
Friese53 Does the file, by any chance, contain a large number of conditional formatting rules, INDIRECT or OFFSET functions? Or perhaps lookup functions that refer to entire columns or rows?
Riny_van_Eekelen thnask for the reply, yes it has quite a a few conditional formatting rules. However the real slow down happened recently, after a few weeks of havign already migrated across to using the Mac. So I thought it was somethign funny going on. I rely on the conditional formatting to make the sheet more readable.
- SergeiBaklanSep 10, 2021Diamond Contributor
Side effect could be if you shifted from Excel which doesn't support dynamic arrays on one which supports. But without the file it's hard to be more concrete.
- Friese53Sep 10, 2021Copper Contributorthanks for the reply - is there a simple way for me to check this?
- SergeiBaklanSep 10, 2021Diamond Contributor
That's only to check your formulas if something suspicious. Sorry, I'm not on Mac and don't know any tools like Inquire exist for it.