On Tue, 11 Dec 2007, Viktor Dalinger wrote:
The Excel-formula, that are stored in one Excel-worksheet and referenced to some other Excel-worksheets, will not be refreshed / calculated after opening of the document.
You will need to either re-calculate the formula values, or add a macro to your sheet to tell excel to do it for you. Otherwise, excel will just display the previous (cached) value without updating it.
See http://poi.apache.org/hssf/eval.html for details about how to re-calculate
Also, this sort of question would be better asked on the users list Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
