There is a demo profile in 2.4
By Johnny Jiang 1 decade ago
There is a demo profile in the database called Demo Case 03 - Excel Templates, you can run it and should be able to see the pivot table and chart get updated and refreshed.
If you open the Excel template attached, you could see some VBA code in there, we use those code to refresh pivot table and charts when switching worksheets. You could build your own Excel templates based on our template.