“Data of the pivot table are not refreshed (for now we use the excel option “refresh data at opening”)”
Currently Aspose.Cells will keep the pivot data if open/save a 2007xlsx format file. But it does not support get/set pivot table and pivot chart from 2007xlsx format file. We are not very clear about your need. Could you give us a template file and sample codes to show and reproduce the problem?
– “With an excel 2007 document the chart is not displayed”
The late versions of Aspose.Cells support to get/set chart data of 2007xlsx format file. If you still find the problem, please give us a template file and sample codes to show and reproduce the problem. We will check and fix it soon if found the problem.