Wait for Excel to calculate

[alagalah]

Hi there,

I have a series of Excel sheets with some heavy calculations (may take about a minute for them to calc).

I want Python to open the spreadsheets and wait until the calc stops before retrieving values.

I have attempted using sleep(60) but would like something a little more "deterministic" . Is there anyway to get a status on when calculations are done?

TIA.

[alagalah]

Actually my problem wasn't with calculation as it does this automatically.

I thought I was access a cell before it had calculated, hence I got bad data.

Turns out I had to launch the Add-In required to calculate the cell as using COM, that doesn't happen!

[bvdet]

Thanks for sharing the solution with us alagalah. :)

-BV