Excel - certain formatting slow on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2739146%22%20slang%3D%22en-US%22%3EExcel%20-%20certain%20formatting%20slow%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2739146%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I%20recently%20got%20a%20new%20macbook%2C%20beofre%20that%20i%20used%20windows%20PC%20and%20suffered%20severe%20hanging%20and%20bombing%20out%20with%20excel%20and%20the%20mahcine%20in%20general.%20Now%20there%20is%20stablity%2C%20which%20is%20great%20but%20recently%20the%20excel%20file%20I%20use%20started%20taking%20several%20minutes%20to%20do%20simple%20things%2C%20speciifcally%20inserting%20columns%20and%20rows%2C%20and%20moving%20cells.%20%26nbsp%3BPlease%20can%20anyone%20assist%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2739146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2739206%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20certain%20formatting%20slow%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2739206%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1151936%22%20target%3D%22_blank%22%3E%40Friese53%3C%2FA%3E%26nbsp%3BDoes%20the%20file%2C%20by%20any%20chance%2C%20contain%20a%20large%20number%20of%20conditional%20formatting%20rules%2C%20INDIRECT%20or%20OFFSET%20functions%3F%20Or%20perhaps%20lookup%20functions%20that%20refer%20to%20entire%20columns%20or%20rows%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2739496%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20certain%20formatting%20slow%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2739496%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bthnask%20for%20the%20reply%2C%20yes%20it%20has%20quite%20a%20a%20few%20conditional%20formatting%20rules.%20However%20the%20real%20slow%20down%20happened%20recently%2C%20after%20a%20few%20weeks%20of%20havign%20already%20migrated%20across%20to%20using%20the%20Mac.%20So%20I%20thought%20it%20was%20somethign%20funny%20going%20on.%20%26nbsp%3B%20I%20rely%20on%20the%20conditional%20formatting%20to%20make%20the%20sheet%20more%20readable.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.  Please can anyone assist? 

6 Replies

@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.

@Friese53 

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.

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

@Friese53 

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.

My excel file is not able find the records I have before with my macro. It worked before. What changed.