poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Beardsley <markbrd...@tiscali.co.uk>
Subject Re: How to force Excel to recalculate on opening xlsx
Date Fri, 05 Nov 2010 15:14:21 GMT

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message