Excel - certain formatting slow on Mac

Question

Hi all, I recently got a new macbook, beofre that i used windows PC and suffered severe hanging and bombing out with excel and the mahcine in general. Now there is stablity, which is great but recently the excel file I use started taking several minutes to do simple things, speciifcally inserting columns and rows, and moving cells. &nbsp;Please can anyone assist?&nbsp;

riny_van_eekelen · Answer

Friese53&nbsp;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?&nbsp;

friese53 · Answer

Riny_van_Eekelen&nbsp;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. &nbsp; I rely on the conditional formatting to make the sheet more readable.

sergeibaklan · Answer

Friese53&nbsp;
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.

friese53 · Answer

thanks for the reply - is there a simple way for me to check this?

sergeibaklan · Answer

Friese53&nbsp;
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.

Forum Discussion

Excel - certain formatting slow on Mac

6 Replies

Resources