+ 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
    365
    Posts
    7,920

    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)

Similar Threads

  1. [SOLVED] Struggling with link between two Excel tables - It works, but it doesn't. : )
    By Elijah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2018, 02:00 PM
  2. VBA Excel - Powerpoint export - Dynamically copy as Images or Tables
    By RPADC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2017, 03:45 PM
  3. Link two pivot tables excel 2007
    By cpramesh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2016, 07:26 PM
  4. Link 2 excel Wokbooks to dynamically update from 1
    By meabrams in forum Excel General
    Replies: 8
    Last Post: 05-11-2016, 11:05 AM
  5. Replies: 0
    Last Post: 03-18-2015, 02:59 PM
  6. Link Excel Spreadsheets to Access Form/Tables
    By _Ryan_ in forum Access Tables & Databases
    Replies: 0
    Last Post: 07-06-2010, 11:52 AM
  7. Dynamically Link Excel Workbooks over A LAN
    By Stacy DeLoren in forum Excel General
    Replies: 2
    Last Post: 08-24-2007, 05:06 AM

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