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
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
