Create a formula which makes it simple to wait for resolution of arguments
The way I can see this working is as follows:
A new formula would be added to the Excel Client called, lets call it CWAITFORME,for now.
This formula would have a minimum of 2 arguments (and a maximum of 20) where:
1) Value / Reference to return to cell when all other arguments are not *Calc*
2) A reference to a cell or cells
3) This argument to argument 20 would be the same as #2 where it would be a range reference for a cell or multiple cells
During calculation, the cell will return *Calc* if any of the cells in its range are *Calc* and if there are none, then it would return the value from the first argument.
To use this in another CALUMO formula, say for example, a CREFLEX, you could make the CWAITFORMEformula return the data source if its ready and then point the data source argument of the CREFLEX to the CWAITFORME cell.
This will cause the CREFLEX to wait to calculate until the CWAITFORME cell is ready.