Share via

Link an Excel file to a Shared Power point

Anonymous
2022-05-31T21:43:02+00:00

Hello,

Can someone help me out to connect a chart from an excel file to a slide in a shared Power point presentation.

I know there's a way to do it for a power point presentation saved in desktop, but how can I do it if I the power point is shared?

Microsoft Teams | Microsoft Teams for business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2022-06-01T02:19:29+00:00

    Hi Pamela,

    Thank you for posting your query in our community.

    Per your description, my understanding is that you want to insert Excel chart into PowerPoint file and share PPT to others, at the same time, the Excel chart in PPT should be up-to-date.

    You can try the following steps:

    1. Upload the two documents to your OneDrive.
    2. Sync OneDrive to your local computer via OneDrive client.
    3. Open these two documents from the local sync folder.
    4. Copy the chart from Excel file, and paste it as link like below image in PPT.
    5. In this way, when you open the documents on the desktop client, the linked data is also refreshed automatically. And the data will be synced to cloud(you may need to open the PPT on your side to make sure the chart in it is updated). So the users who opened the shared PPT will also see the latest chart.

    Best regards,

    Jazlyn

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-06-02T18:46:05+00:00

    Hi Jazlyn,

    Thank you very much for you help!

    It works when I follow the steps if the Excel and Power Point are shared in my personal One drive.

    But I am trying to do it in the from the Shared drive across my team and when trying to paste the excel chart in the power point, the "Paste Special" option doesn't comes up (image below), therefore I am not able to link the image.

    Do you know why does this happens? Am I doing something wrong?

    thank you,

    pamela

    0 comments
  2. Anonymous
    2022-06-03T03:36:02+00:00

    Hi Pamela,

    Thank you for the reply.

    You mentioned that you can't find "Paste special" option in the file which saved to a shared drive, I want to explain that the shared drive is a personal drive of your organization, it has different environment with OneDrive. So we can't deploy the same environment as your company's on our side.

    Given this situation, we suggest that you could contact your administrator and let him to help troubleshooting this issue on your organization environment.

    And since those steps worked well in OneDrive on your side, to not delay your work, we suggest you use OneDrive as a workaround.

    Appreciate your understanding.

    Best regards,

    Jazlyn

    0 comments