Excel dynamic name range chart not refreshed in TM1 web
Posted: Thu Jun 20, 2019 11:34 am
I have set up a dynamic name range referencing a range of data which use Offset to reference ActiveForm data.
Dynamic range similar to below Then I created a pie chart based on the name range.
In Excel, I change SUBNM selection and rebuild, the ActiveForm updates and so as the pie chart, perfect!
However, the pie chart does not update anymore once the workbook is uploaded to TM1 web. I did some research and found a related IBM reported error about chart with OFFSET datasource not rendered probably.
Does anyone know a workaround?
Thanks in advance.
Dan
Office 365
PA 2.0.6 Perspective
Dynamic range similar to below Then I created a pie chart based on the name range.
In Excel, I change SUBNM selection and rebuild, the ActiveForm updates and so as the pie chart, perfect!
However, the pie chart does not update anymore once the workbook is uploaded to TM1 web. I did some research and found a related IBM reported error about chart with OFFSET datasource not rendered probably.
Does anyone know a workaround?
Thanks in advance.
Dan
Office 365
PA 2.0.6 Perspective