[CAFE 10.2] How can I copy a worksheet to another workbook ?
Posted: Sun Jul 26, 2015 7:00 am
Hi,
We combine TM1 Perspectives 10.2.2 and CAFE 10.2.2 on Excel 2010 to create a sales planning tool for an automobile company. The two addins used are the IBM Cognos TM1 Perspectives addin and the IBM Cognos Office Reporting BI addin.
I'm trying to copy a worksheet to another workbook through the Excel classic operation, but CAFE doesn't recognize the new sheet, there's no toolbar and data cannot be refreshed. So I assume that there may be an Excel Name conflict, then I add manually new Name definitions into .\xl\workbook.xml and .\docProps\app.xml, a quadruple like tm1\\_0_C, tm1\\_0_R, tm1\\_0_S and tm1\\_0_H. Always neither toolbar nor data refresh.
Anybody has a diffrent idea ? It's hardly to believe that CAFE is lacking this kind of basic functionnality.
Thanks
Regards
We combine TM1 Perspectives 10.2.2 and CAFE 10.2.2 on Excel 2010 to create a sales planning tool for an automobile company. The two addins used are the IBM Cognos TM1 Perspectives addin and the IBM Cognos Office Reporting BI addin.
I'm trying to copy a worksheet to another workbook through the Excel classic operation, but CAFE doesn't recognize the new sheet, there's no toolbar and data cannot be refreshed. So I assume that there may be an Excel Name conflict, then I add manually new Name definitions into .\xl\workbook.xml and .\docProps\app.xml, a quadruple like tm1\\_0_C, tm1\\_0_R, tm1\\_0_S and tm1\\_0_H. Always neither toolbar nor data refresh.
Anybody has a diffrent idea ? It's hardly to believe that CAFE is lacking this kind of basic functionnality.
Thanks
Regards