Excel 365 version 16.44 - very slow - paste entire row function

%3CLINGO-SUB%20id%3D%22lingo-sub-2060383%22%20slang%3D%22en-US%22%3EExcel%20365%20version%2016.44%20-%20very%20slow%20-%20paste%20entire%20row%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060383%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20the%20last%20few%20months%20excel%20(%20paste%20function%20)%20is%20extremely%20slow.%3C%2FP%3E%3CP%3EThe%20spreadsheet%20I%20am%20using%20is%20not%20massive%20around%206000%20rows%20and%20a%20few%20pivot%20tables%20linked%20to%20a%20couple%20of%20worksheets.%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20add%20an%20entire%20row%20or%20column%20is%20takes%20a%20few%20minutes%20to%20do%20so%2C%20the%20little%20cycle%20goes%20round%20and%20round%20like%20its%20going%20to%20freeze%20..%20it%20is%20so%20much%20time%20consuming%20task...%20that%20should%20take%20sec%20not%20minutes..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%20365%20subscription%20version%2016.44%3C%2FP%3E%3CP%3EHow%20can%20I%20fix%20it%3F%20Please%20help!!!!%26nbsp%3B%20Any%20suggestions%20would%20be%20much%20appreciated%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2060383%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2060782%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20version%2016.44%20-%20very%20slow%20-%20paste%20entire%20row%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060782%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928872%22%20target%3D%22_blank%22%3E%40iainandkamila%3C%2FA%3E%26nbsp%3BWhat%20kind%20of%20Mac%20are%20you%20on%3F%20What%20OS%3F%20Does%20the%20sheet%20have%20many%20conditional%20formats%2C%20(V)LOOKUP%20functions%20and%2For%20functions%20with%20INDIRECT%20or%20OFFSET%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2062249%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20version%2016.44%20-%20very%20slow%20-%20paste%20entire%20row%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2062249%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%3B%20thank%20you%20for%20your%20reply%20is%20Mac%20BIG%20SUR%26nbsp%3B%20vesion%2011.1%20there%20is%20only%20one%20conditional%20formating%20(%20one%20column)%20no%20vlookup%20functions.%20there%20are%2010%20worksheets%26nbsp%3B%20(%20but%20only%201%20has%20approx%206000%20lines%20another%202000%20lines%20and%203%20worksheets%20are%20pivot%20table%20(%20data%20source%20that%202%20worksheets)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anything%20I%20can%20do%20to%20speed%20up%20the%20process%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there

 

for the last few months excel ( paste function ) is extremely slow.

The spreadsheet I am using is not massive around 6000 rows and a few pivot tables linked to a couple of worksheets.

When I try to add an entire row or column is takes a few minutes to do so, the little cycle goes round and round like its going to freeze .. it is so much time consuming task... that should take sec not minutes..

 

I am using Excel 365 subscription version 16.44

How can I fix it? Please help!!!!  Any suggestions would be much appreciated it

 

Thank you

 

 

3 Replies

@iainandkamila What kind of Mac are you on? What OS? Does the sheet have many conditional formats, (V)LOOKUP functions and/or functions with INDIRECT or OFFSET?

@Riny_van_Eekelen  thank you for your reply is Mac BIG SUR  vesion 11.1 there is only one conditional formating ( one column) no vlookup functions. there are 10 worksheets  ( but only 1 has approx 6000 lines another 2000 lines and 3 worksheets are pivot table ( data source that 2 worksheets)

 

Is there anything I can do to speed up the process ?

@iainandkamila Difficult to diagnose. Sorry. Running quite big files on a not very powerful MB Air (Big Sur, and Excel v. 16.46 beta). Am not experiencing the problems you describe.