There are some formulas with mixed internal classes that Spreadsheet::WriteExcel doesn't parse correctly. The effect is as you describe; Excel doesn't calculate the formula correctly until it is forced to. This is a known issue.

If you post a small working example to the Spreadsheet::WriteExcel Google Group I can suggest a workaround.

--
John.