Is there an Excel add-in to check where the spreadsheet is lagging the most?

%3CLINGO-SUB%20id%3D%22lingo-sub-2280208%22%20slang%3D%22en-US%22%3EIs%20there%20an%20Excel%20add-in%20to%20check%20where%20the%20spreadsheet%20is%20lagging%20the%20most%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280208%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20made%20a%20spreadsheet%20over%20a%20period%20of%20time%20with%20multiple%20complex%20formulas%20and%20a%20lot%20of%20thread%20calculations.%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20the%20sheet%20has%20gone%20slow%20even%20when%20the%20primary%20data%20is%20not%20there.%3CBR%20%2F%3EI%20can't%20point%20to%20a%20single%20formula%20which%20is%20taking%20the%20most%20load.%3CBR%20%2F%3EI%20wanna%20optimize%20the%20file%2C%20by%20updating%20or%20removing%20the%20formulas%20which%20are%20causing%20the%20most%20lag.%3CBR%20%2F%3EI%20saw%20some%20add%20in%20before%20that%20could%20analyze%20the%20whole%20sheet.%20Can't%20remember.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20one%3F%20Can%20you%20send%20me%20the%20link%20to%20it%3F%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%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%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2280208%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280270%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20Excel%20add-in%20to%20check%20where%20the%20spreadsheet%20is%20lagging%20the%20most%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280270%22%20slang%3D%22en-US%22%3EPerhaps%20this%20is%20what%20you%20are%20thinking%20of%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fwww.decisionmodels.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.decisionmodels.com%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Contributor

I've made a spreadsheet over a period of time with multiple complex formulas and a lot of thread calculations.

Now the sheet has gone slow even when the primary data is not there.
I can't point to a single formula which is taking the most load.
I wanna optimize the file, by updating or removing the formulas which are causing the most lag.
I saw some add in before that could analyze the whole sheet. Can't remember.

Is there one? Can you send me the link to it?
@Peter Bartholomew @Sergei Baklan @Detlef Lewin @Riny_van_Eekelen 

1 Reply