Is there a clever way to determine which aspect of a big workbook is costing the most calc time?

1. Use Excel's now() function to post the current time (or time deltas)2. Create some VBA code to log when the calculation hits certain key points.Neither are that easy (fails your cleverness test) because one has to get the dependencies right both upstream and downstream of the timing points. The timing code needs to be in a position that forces Excel to finish computing some chunks of the spreadsheet before calling the time function and forces Excel to call the time function before beginning other chunks of the spreadsheet. My impression of Excel's order of execution is that is NOT strictly row first or column first, but is based on the dependency graph and is affected by recent partial recalcs.

Check out the following site. FastExcel is designed for this purpose. http://www.decisionmodels.com/

QuoteOriginally posted by: Traden4Alpha1. Use Excel's now() function to post the current time (or time deltas)2. Create some VBA code to log when the calculation hits certain key points.Neither are that easy (fails your cleverness test) because one has to get the dependencies right both upstream and downstream of the timing points. The timing code needs to be in a position that forces Excel to finish computing some chunks of the spreadsheet before calling the time function and forces Excel to call the time function before beginning other chunks of the spreadsheet. My impression of Excel's order of execution is that is NOT strictly row first or column first, but is based on the dependency graph and is affected by recent partial recalcs.Gotcha.Thanks!

QuoteOriginally posted by: MMPCheck out the following site. FastExcel is designed for this purpose. http://www.decisionmodels.com/Thanks. I'll check it out