Page 1 of 1

Excel dynamic name range chart not refreshed in TM1 web

Posted: Thu Jun 20, 2019 11:34 am
by danz
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
Capture.PNG (13.51 KiB) Viewed 6113 times
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.

Office 365
PA 2.0.6 Perspective