+ Reply to Thread
Results 1 to 2 of 2

Linking dynamic Excel data/pivot tables to PPT that auto update number rows/columns

  1. #1
    Registered User
    Join Date
    12-30-2019
    Location
    London
    MS-Off Ver
    365
    Posts
    5

    Linking dynamic Excel data/pivot tables to PPT that auto update number rows/columns

    Hi there!

    I am trying to create automated PowerPoint presentations for clients that automatically refresh every month with new data. Linking pivot charts is straightforward but I am having a problem with linking dynamic data tables or pivot tables from Excel to PPT - I need the tables in PPT to update with increases/decreases in number of rows/columns in the original Excel. Does anyone have any advice on how to do this please?

    Many thanks in advance for any support!

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,248

    Re: Linking dynamic Excel data/pivot tables to PPT that auto update number rows/columns

    Overlay the pivot table with a named dynamic range. See this wiki on how to do this: http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges.

    Then see this utility to add a chart or range to a PowerPoint Presentation. It should work with named dynamic ranges as well as fixed ranges. https://www.excelforum.com/tips-and-...rom-excel.html.

    If you need any help, provide a sample Excel workbook and PowerPoint presentation.
    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. Replies: 1
    Last Post: 10-08-2019, 02:37 AM
  2. Replies: 3
    Last Post: 12-04-2017, 01:55 PM
  3. Replies: 5
    Last Post: 12-04-2017, 10:33 AM
  4. Help with Excel tables to copy dynamic data update
    By gigiw1986 in forum Excel General
    Replies: 1
    Last Post: 04-24-2010, 06:54 AM
  5. Replies: 0
    Last Post: 01-15-2009, 06:32 PM
  6. Auto update pivot tables
    By houstonguy in forum Excel General
    Replies: 2
    Last Post: 01-31-2008, 05:04 PM
  7. [SOLVED] Putting data into pivot tables in columns not rows.
    By ACP in forum Excel General
    Replies: 1
    Last Post: 08-24-2005, 09:05 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