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 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??

 

Jessica

 

powerpoint
  • HenryPhillipsNimbitech's avatar
    HenryPhillipsNimbitech
    Bronze Contributor
    Aug 28, 2020

    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?

     

    Thanks

     

    Henry

      • 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

  • nurfahimfitriyanto's avatar
    nurfahimfitriyanto
    Copper Contributor
    Apr 19, 2022

    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

     

    Fahim

Resources