Home

Excel was running very slow

%3CLINGO-SUB%20id%3D%22lingo-sub-760166%22%20slang%3D%22en-US%22%3EExcel%20was%20running%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-760166%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Microsoft%20Excel%20for%20Mac%20Version%2016.26%20as%20part%20of%20office%20365%20subscription.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20maintain%20invoices%20of%20my%20business%20into%20one%20spreadsheet%20with%20many%20different%20sheets%20as%20they%20reflect%20vendors.%20I%20do%20calculations%20on%20each%20item%20about%20my%20expenses%20and%20selling%20price.%26nbsp%3B%20Each%20sheet%20has%20many%20invoices%20and%20corresponding%20calculations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELately%20I%20am%20seeing%20whenever%20I%20add%20a%20row%20or%20touch%20a%20cell%20or%20scrolling%20the%20sheet%20it%20is%20taking%20lot%20of%20time%20and%20showing%20as%20%22Application%20not%20responding%22%20Especially%20some%20of%20the%20sheets%20even%20slower.%20I%20did%20my%20research%20and%20I%20couldn't%20find%20any%20solution%20to%20resolve%20this.%20Can%20anyone%20from%20the%20community%20help%20me%20out%20how%20to%20fix%20this%20issue%20%3F%20Appreciate%20help%20on%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-760166%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eexcel%20for%20mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-762138%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20was%20running%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762138%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F183125%22%20target%3D%22_blank%22%3E%40Srini%20Sanagapalli%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20using%20any%20of%20the%20volatile%20functions%20like%20INDIRECT()%20or%20OFFSET()%20and%20have%20lots%20of%20these%20in%20your%20formulae%2C%20that%20could%20be%20the%20cause%20of%20the%20slowing%20down.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20need%20to%20have%20separate%20sheets%20for%20each%20vendor%3F%3C%2FP%3E%0A%3CP%3ECould%20you%20not%20just%20have%20all%20the%20data%20in%20your%20one%20sheet%2C%20and%20just%20Filter%20for%20any%20particular%20vendor%3F%20That%20would%20get%20rid%20of%20the%20need%20for%20lots%20of%20your%20formulae.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-778543%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20was%20running%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778543%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106033%22%20target%3D%22_blank%22%3E%40Roger%20Govier%3C%2FA%3E%26nbsp%3BI%20don't%20have%20functions%20like%26nbsp%3B%3CSPAN%3EINDIRECT()%20or%20OFFSET().%20Mostly%26nbsp%3B%20are%20something%20like%20these%20F36%2B(F36*%24R%2441)%2C%20RIGHT(D397%2C%202)%20like%20these%20simple%20functions.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20having%20different%20sheets%20for%20each%20vendor%20I%20can%20manage%20data%20differently%20for%20each%20particular%20vendor.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20still%20exist.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Srini Sanagapalli
Occasional Contributor

I am using Microsoft Excel for Mac Version 16.26 as part of office 365 subscription.

 

I maintain invoices of my business into one spreadsheet with many different sheets as they reflect vendors. I do calculations on each item about my expenses and selling price.  Each sheet has many invoices and corresponding calculations.

 

Lately I am seeing whenever I add a row or touch a cell or scrolling the sheet it is taking lot of time and showing as "Application not responding" Especially some of the sheets even slower. I did my research and I couldn't find any solution to resolve this. Can anyone from the community help me out how to fix this issue ? Appreciate help on this.

2 Replies

@Srini Sanagapalli 

 

If you are using any of the volatile functions like INDIRECT() or OFFSET() and have lots of these in your formulae, that could be the cause of the slowing down.

 

Do you need to have separate sheets for each vendor?

Could you not just have all the data in your one sheet, and just Filter for any particular vendor? That would get rid of the need for lots of your formulae.

 

@Roger Govier I don't have functions like INDIRECT() or OFFSET(). Mostly  are something like these F36+(F36*$R$41), RIGHT(D397, 2) like these simple functions.

 

Also having different sheets for each vendor I can manage data differently for each particular vendor. 

 

My problem still exist.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies