Perforance Analysis of a Workbook

NatetheGreat

Active Member
Joined
Nov 18, 2013
Messages
268
HI All,

I have a workbook with many charts, formulas and analysis within it, that gets data imported and runs loads of calculations on the import files which range between 100-30,000 rows. The import file usually has around 10 columns, and a further 20 or so columns within the masterworkbook exist that calculate various things against the imported data to feed the charts and analysis etc.

When feeding in larger import files, the workbook takes a very long time to run through its code (can't really post the code, its very long). I want to know if there is any way of probing which specific formulas are slowing it down.

I know that vlookups are very slow, but I mainly have Offset(match) type formulas that scan up the rows to find original ID's and things of that nature. Is there any self auditing analysis in VBA or excel directly?

Thanks
Nate
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,108,626
Messages
5,523,982
Members
409,550
Latest member
baaabies

This Week's Hot Topics

Top