Forum Discussion

JHruz's avatar
JHruz
Copper Contributor
Aug 27, 2020

Excel linked to PPT not updating, in Teams Site

Hello -    I have a standard PPT document, which contains linked charts/graphs in an excel file. For some reason in the teams site, the links will not update in the PPT. I get errors saying it can ...
powerpoint
JHruz's avatar
JHruz
Copper Contributor
Aug 30, 2020

HenryPhillipsNimbitech This is 100% accurate, exactly as you have described. Thank you for taking a look. 

HenryPhillipsNimbitech's avatar
HenryPhillipsNimbitech
Bronze Contributor
Aug 31, 2020

Hi JHruz ,

So I tested this. An Excel file with a PowerPivot Chart, a PPT that had the Graph pasted in with the paste option of doing it with a link.

 

All seemed to work well, apart from I had to do the paste via the Desktop version of the respective Office Apps and also had to do the refreshing via the PowerPoint Desktop app to get the option.

 

It did however render the latest version of the chart based on the last refresh within Teams OK.

 

So we have to remember that Teams to render Office docs within Teams, basically makes use of the Web version of the respective Office App, which does have limitations over the Desktop version, as per:

 

https://support.microsoft.com/en-us/office/how-certain-features-behave-in-web-based-powerpoint-a931f0c8-1305-4428-8f7c-9cfa00ef28c5

 

However you mentioned you got an error not just that the data was outdated. So could you advise exactly how you added the chart into Excel please.

 

Thanks

 

Henry

  • Marshall0901's avatar
    Marshall0901
    Copper Contributor
    Dec 10, 2020
    Very Helpful. Thanks!
    Marshall
  • TWKoszel's avatar
    TWKoszel
    Copper Contributor
    Nov 23, 2020

    HenryPhillipsNimbitech I too have the same problem, always open both in the desktop app and today went to refresh and it opened what I can only presume was the version it was created from originally not the most up to date version.  They are both in the same teams area, the excel file never changes name or moves, the powerpoint gets a date reference change as it is shared further than teams once updated.

Resources