title: Links to Excel break in Powerpoint
body: <p>I am using Office 2016. I created dynamic Charts in Excel, meaning that I named data ranges which expand as new data is fed into the excel. I transfered the Excel Charts to PowerPoint and pasted with "Keep Source Formatting &amp; Link Data". However, as soon as I close and reopen the PowerPoint and refresh the graphs, the link to the Excel gets lost. This is how the data source looks like: </p>
  
  <p><a href="https://i.stack.imgur.com/EEs6v.png" rel="nofollow noreferrer">As you can see, instead of the Excel file Name I only get "[0]"</a> </p>
  
  <p>I tried to find the source for this mistake but couldn't find anything other than this Forum entry without solution: <a href="https://stackoverflow.com/questions/41144733/problems-with-linked-excel-charts-in-powerpoint">Problems with Linked Excel Charts in Powerpoint</a> </p>
  
  <p>I have tried to paste the graphs as excel chart object in PowerPoint and in this case to problems with the link do not occure. However, I hope to find another solution since I need to format the graphs in PowerPoint, which is not possible with Excel chart objects. </p>
  
  <p>Since I couldn't find any documentation on this bug, I thought could maybe work around by using a VBA to replace the [0] in the chart data source with the actual file path. If I do so manually it solves the problem - until I save and close the ppt again. I tried several scripts I found here to change links to excel graphs in powerpoint, but wasn't able to make any of them work. </p>
  
  <p>My question: 
  1) Is anyone familiar with this problem with dynamic excel-graphs in powerpoint and can point me to a solution?
  2) If not: could anyone point me to a VBA script which can replace [0] with a correct filepath?</p>
  
  <p>Thank you very much for any help and best regards,
  Clemens</p>