+ Reply to Thread
Results 1 to 2 of 2

Dynamically link excel chartes and tables in ppt

  1. #1
    Registered User
    Join Date
    02-01-2018
    Location
    usa
    MS-Off Ver
    2013
    Posts
    6

    Dynamically link excel chartes and tables in ppt

    Hi,

    I have created few charts and tables in a excel file and have linked the same in ppt. So when I update data in excel it is auto update in ppt.

    I have used the following ways:

    For Charts: I have pasted the chart in ppt with "Source formatting and data link" option and after that i have set the link to auto update from the path: File>Info>Edit Links to file
    For Tables : I have copied, paste special, past link as chart objects.

    This approach is working file on my PC but when I email the ppt and excel file to someone else. And if someone opens the ppt files and press the update link option it is given the message that the file is not linked.

    Can someone tell me why it is not working??

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    6,966

    Re: Dynamically link excel chartes and tables in ppt

    If the user does not have access to the source file, they can't update it. The end user has to "make do" with a static chart or table.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1