Excel chart not updating
Solved
Debutantexcel8
Posted messages
25
Status
Membre
-
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur Last intervention -
Hello,
I have an Excel file in which all the data as well as pivot tables and charts update after running a macro.
However, very recently, the data displayed on the charts and that contained in the corresponding tables, despite the update, differ by just one decimal point.
More concretely, for example, if a cell in the table has 100%, then the chart shows 10%.
When I click on the "refresh all" option, the charts display the exact data, namely 100% in the example above. But when I close the file while saving it, then reopen it, the chart data is again different from that in the tables, and in the above example, I find 10%. Sometimes, upon reopening the file, some chart data matches the table data...and then in the next reopening, it is no longer the case. I don't know where this error might be coming from. Does anyone have any ideas? Thanks.
I have an Excel file in which all the data as well as pivot tables and charts update after running a macro.
However, very recently, the data displayed on the charts and that contained in the corresponding tables, despite the update, differ by just one decimal point.
More concretely, for example, if a cell in the table has 100%, then the chart shows 10%.
When I click on the "refresh all" option, the charts display the exact data, namely 100% in the example above. But when I close the file while saving it, then reopen it, the chart data is again different from that in the tables, and in the above example, I find 10%. Sometimes, upon reopening the file, some chart data matches the table data...and then in the next reopening, it is no longer the case. I don't know where this error might be coming from. Does anyone have any ideas? Thanks.
