workbook.CalculateAllValue () .... speed ?

[majachen]

Hello,
We have a large Excel project with many calculations (over several pages).
If I change a value in a cell and use

Code: Select all

workbook.CalculateAllValue ()

,
the calculation takes about 10s.
With open Excel (via Com interface) about 2s.

What can I change to increase the speed?

Thanks for the quick reply

[Betsy.jiang]

Dear majachen,

Thanks for your inquiry.
We will appreciate it if you could provide us the sample file for testing on my side. And then we will investigate it and then update to you.

Thanks,
Betsy
E-iceblue support team