As you are targetting the more recent version of Exce; - Office 2007 on - you do have another option, a macro. It is possible to create a macro within a workbook and stipulate that it be run when the workbook is opened; that macro can force a recalculation of all forumals in the workbook using a single command - Calculate. Excel 2007 intorduced the xlsm file which can contain signed macros and avoid the problem of the user being asked if macros should be run or not.
So, you can create a workbook that includes such a macro and use this as the basis for the workbook you create using POI. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-force-Excel-to-recalculate-on-opening-xlsx-tp3249595p3251971.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
