Linking , AUTO updating charts in power point based on changes in source XL sheet

[Subu]

Hi

I use MS office 2010 version 14.0.7xyz on a windows 7 machine

I've have a spread sheet with charts.

I wish to insert and link these charts into a PowerPoint presentation in such a way that when I edit data in the *spreadsheet*, the chart on *PowerPoint* slide should auto update

I will save both these files on my local folders. I will have access to both files at the same time. So there are no access issues (As I see)

I do not want to go chart by chart, click on design tools and keep clicking refresh data... Basically I am looking for AUTO updating

Sample XL sheet and power point file are uploaded here https://app.box.com/s/ossopxsbyxa6xlersvh7


Thanks in advance
Best regards
Subu

 

[Subu]

post above updated here (as I crossed the 10 min limit)
====================================================

Hi

I use MS office 2010 version 14.0.7xyz on a windows 7 machine

I've have a spread sheet with charts. I wish to insert and link these charts into a PowerPoint presentation in such a way that when I edit data in the *spreadsheet*, the chart on *PowerPoint* slide should **auto update**. AUTO is the key !

I will / I can save both these files on my local folders. I have access to both files at the same time. So there are no access issues.

What have I tried :
=================
I've read and inserted the chart link from XL into PPT as mentioned here : Automatic Updating of Excel Tables in PowerPoint Slides | Think Outside The Slide

When I try this, it works just the first time (when both XL and ppt are not closed). After the files are closed , I do NOT get auto updating !! I am forced to refresh data chart by chart to get fresh #s in the ppt

I do not want to go chart by chart, click on design tools and keep clicking refresh data... Basically I am looking for AUTO updating

Sample XL sheet and power point file are uploaded here https://app.box.com/s/ossopxsbyxa6xlersvh7


Thanks in advance
Best regards
Subu