Error on CalculateSheet
Posted: Mon Dec 04, 2006 2:20 pm
After upgrading to version 3.0 and applying the 3.00.06 update, I am still getting errors where the previous version had none.
Currently, having set up the formula etc, on the first CalculateSheet I get
'Calculate error on cell' which has the following formula
((-A1*A2)+A3+(A4*A5)+(A6*0*(1-A7))+(Erate*(A8+A9)))/A10
where Erate is named cell with another formula. It's quite a complex spreadsheet, but was working ok with version 2.0. If you need an example of the spreadsheet, let me know.
Currently, having set up the formula etc, on the first CalculateSheet I get
'Calculate error on cell' which has the following formula
((-A1*A2)+A3+(A4*A5)+(A6*0*(1-A7))+(Erate*(A8+A9)))/A10
where Erate is named cell with another formula. It's quite a complex spreadsheet, but was working ok with version 2.0. If you need an example of the spreadsheet, let me know.