Hi, I have a Excel 2010 xlsm macro-enabled workbook containing a macro and a couple of work sheets. If I create a XSSFWorkbook from this file, then rename a sheet using POI, the modified .xlsm file can not be opened without closing the "Edit Links" window.
Does anyone know of a way to also update all references to the sheet name when renaming the sheet? (I am sure this used to work using HSSF!) Thanks, Edit links dialog displayed: <http://apache-poi.1045710.n5.nabble.com/file/n5715370/excel2010_screen1.jpg> Reference to the workbook's original sheet name still exists: <http://apache-poi.1045710.n5.nabble.com/file/n5715370/excel2010_screen2.jpg> When I press close the workbook looks ok, and shows the new sheet name. The screen displayed after poi is closed and file is opened: <http://apache-poi.1045710.n5.nabble.com/file/n5715370/excel2010_screen3.jpg> This is how I am renaming the worksheet: This is the macro within the workbook: *Using java 1.7.0_11, POI 3.1.0-FINAL, opening workbook on Windows 7, Excel 2010* -- View this message in context: http://apache-poi.1045710.n5.nabble.com/XSSF-problem-with-renamed-sheets-containing-macros-tp5715370.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]
