Formula Does Not calculate automatically

May 15, 2010 at 10:45 PM

I've been using the PHPExcel Class for some development today and everything was running fine (fantastic open-source work) until I ran into this problem.  I tried to set the following formula:


And the excel file shows a calculation error (#VALUE!), until I double-click into it and hit enter, then everything is fine.  Is there something off with my syntax or is there  property I should be setting?


May 15, 2010 at 10:57 PM
Edited May 15, 2010 at 10:58 PM

Quoting from the FAQ

Formulas don’t seem to be calculated in Excel2003 using compatibility pack?
This is normal behaviour of the compatibility pack, Excel2007 displays this correctly. Use PHPExcelWriterExcel5 if you really need calculated values, or force recalculation in Excel2003.

Is this the problem?

Aug 13, 2010 at 11:11 PM

For future reference - in Excel2003, Ctrl-Alt-F9 will force a complete recalculation.