How can we improve PowerPoint for Mac? Vote for an existing idea or share a new one.

Enable changing source files of linked Excel charts from Powerpoint

When an excel chart is inserted in powerpoint the data och the chart is linked to an excel spreadsheet.

In the windows version it is possible to change the source file of the linked data. It is not possible to do this in powerpoint 2016 for Mac.

102 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Nicko shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    23 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • justbeez commented  ·   ·  Flag as inappropriate

        We have a huge problem with this in our team because we have both PC and Mac users. When presentations with linked charts created on a Mac are edited on a PC, not only do errors show on the Macs (one per chart every time the file is opened!!!), the linked charts can no longer be updated.

        In order to work around this, I have to decompress the PPTX container, find/replace the mangled link path in the XML .rels, and then re-save/re-compress the file for my coworkers to be able to work with it.

        (So there's a second feature request here—the PC version shouldn't flip the direction of the slashes in the Mac links!!!)

      • Dan(N) commented  ·   ·  Flag as inappropriate

        This is really frustrated and as I can see this has been reported long time ago and still no ACTION.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Even better, embed the excel file into the xml structure the same way media files are handled.

      • Anonymous commented  ·   ·  Flag as inappropriate

        How about allow the excel file to be saved within the powerpoint file so you don't even need to edit links.

      • Tracy commented  ·   ·  Flag as inappropriate

        So disappointing. Just got an iMac for first time and this is crucial to my work.

      • - commented  ·   ·  Flag as inappropriate

        Why has this ideation topic been open for such a long time? This is a very basic request and very annoying not to have this feature available in Office for Mac! PLEASE FIX

      • Ryan commented  ·   ·  Flag as inappropriate

        Scott, why do you ignore people's requests like this? It's a very basic one. Disappointing.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Under review for coming up on 2 years now. Any updates from the team, please? And please add Mac support for linking to excel charts, worksheets, ranges etc, just as can be done under Windows.

      • Fabian Voß commented  ·   ·  Flag as inappropriate

        This is a real essential feature in reporting and management!

        #upvoted

        PS: I recently posted and pictured the exact same situation in a longer post on a Microsoft Help Community. Maybe not on point, but possibly useful when (hopefully) fixing that issue soon: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_powerpoint-mso_mac-mso_o365b/office-mac-powerpoint-does-not-update-linked-data/1c601937-0bdc-43e3-8934-2901e362e4fa

      • Anonymous commented  ·   ·  Flag as inappropriate

        I rely on this function, as I produce monthly reports in a 80 page doc, each page slide of which contains multiple graphs. Sometimes I move computers, or the file moves, or the file name is updated to reflect the current year. For each of these I need to update the source file path and name. Please assist ASAP. I'm considering moving back to windows if I have to spend days on this robotic task each month. Thank you.

      • Axel commented  ·   ·  Flag as inappropriate

        This is a no-brainer, because as a user you end up in a dead end situation with no other option than starting all over again...

      • BryceD commented  ·   ·  Flag as inappropriate

        Its in PC I believe this should be in the Mac version (I only have access to mac and have to use the XML hack in the mean time)

      • Jason commented  ·   ·  Flag as inappropriate

        You should just be able to right click on the chart and change the source data file.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Please YES, give the Mac the ability to link to spreadsheet data & charts. Not having this is like running a footrace with your feet amputated.

      ← Previous 1

      Feedback and Knowledge Base