Worksheet Formula Profile - Surprising Result Query

[adsta...@gmail.com]

Hi,

I have recently installed and started using a trial version to see what utility I'd get out v4 as I believe it could be useful.

If you see the image below this formula is meant to take 16% of the calculation time, out of a large financial model database.

Now this seems strange to me as it's literally a simple addition of changes in headcount over time.

My only guess is because it's pulling the numbers from another sheet that may take longer but all the same given it's simplicity thought it would level out.

Be interested to hear your thoughts.

Thanks,

Paul

[Charles Williams]

Hard to tell without more context, but

Is this repeatable?

What timing do you get if you use the Range Calculate button on a block of these formulas?

What timing do you get if reverse the formula to =Payroll!P83 + AS42975 ?

Do you have circular references or iterative data tables?

[adsta...@gmail.com]

Sorry for the delay in responding Charles.

It is repeatable as it take an opening headcount then creates an updated headcount which changes by the +/- change in the month which is used as the basis for the following month.

Yep range calculate still takes a while as well.

Same issue unfortunately.

As above there iterative in the same it's a built up sum month on month, no circular errors though.

Thanks,

Paul

[Charles Williams]

Well - you obviously have something strange going on somewhere: what else does FastExcel tell you?

- conditional formatting?

- VBA?

- Data Tables?

- Weird dependency chains?

- Very large cell table?

- Large memory use?

- ...?

[adsta...@gmail.com]

Just to round this off this code has fixed the slow speed, don't ask me why!

Found in this thread online.

ActiveWorkbook.ForceFullCalculation = True

https://www.excelforum.com/excel-general/1065660-table-slow-after-manual-calculation.html

[Charles Williams]

Workbook.ForcefullCalculation switches off dependency tracking.

It is controllable from FastExcel Calculation Manager. The calc Manager enables all available calculation methods and controls