XSSF problem with renamed sheets containing macros?

[Levelled Land <le...@yahoo.co.uk>]

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