Powerpoint chart data not updating K9 sex site for meeting uk
Once you have embedded a chart, be careful not to delete or move the original Excel file.
If the location of either the Power Point presentation or the Excel file changes, you may have to embed the chart again in order for it to display correctly.
Messing with vb doesn't seem like a durable solution to me (other people are sometimes affected in my company on different files).
I am really curious about what is the source of this to be honest.
(I'm not a chart guru, so this was a big help) I included the command i used below: Add the statement to a macro that steps through and formats the text or fonts etc.
It is the first time it happens to me and I checked everywhere online and I don't see any reported issues that is similar to what I have or that provide a more satisfying solution than vba code. It is correctly linked to the source (no values hard coded).
The calculations are set on automatic for the workbook. I tried setting up an other chart in the same worksheet, linked to only one simple row and this new chart has the same refreshing issue so I suspect it has to do with settings or something like that but for the life of me I can't find which settings could do this.
in your chart labels and the chart should update again when your data changes.
I think in my case somehow this option was turned off.