Aug 26 2020
- last edited on
Apr 01 2022
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 not find the file. I created the PPT and Excel in the teams site, and then created the links in PPT same place (meaning I didn't move it from somewhere else). But, the PPT link won't update or connect. Any suggestions??
Aug 28 2020 02:48 PM
Hi @JHruz ,
I will have a play with this one.
Just to confirm though. You have an Excel file with say a Graph and PPT that is referencing said Graph, in said Excel file. Both files housed in the same SharePoint site backing the Team. However when you come to launch the PPT the Graph cannot be found as it is saying it cannot be found?
Aug 30 2020 03:59 PM
@HenryPhillipsNimbitech This is 100% accurate, exactly as you have described. Thank you for taking a look.
Aug 31 2020 12:47 PM
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:
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.
Nov 23 2020 07:35 AM
@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.
Apr 19 2022 12:39 AM
Hi.. I have similar problems since moving to teams, which I did not face when it was still a simple local drive or even the shared drive.
1. I used to paste link from excel ("xls 1") to ppt for the routine routine ppt reporting ("ppt 1") --> paste link can be table on the excel sheet, graph or else
2. Moving to next following month, I simply copied the "ppt 1" to be "ppt 2" (or through save as function) and the "xls 1" to xls 2" (same way) to the new month folder
3. Once I finished the "WORK" on the "xls 2" for the new month numbers/analysis, I then opened the "ppt 2", and go to each slide which has table/graph linked to the "xls 1", and do the change link from "xls 1" to "xls 2" though the function edit link and the change source link
4. Since moving to team, this is not doable anymore (so I need to copy and paste link for everything, which takes time and not effective).
Any input so I can do as old time? Thanks