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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,114,650
Messages
5,549,183
Members
410,903
Latest member
natesreich
Top