+ Reply to Thread
Results 1 to 10 of 10

PIVOT Table on Powerpoint

  1. 12-13-2014, 11:31 AM #1
    jsuarez199
    jsuarez199 is offline
    Registered User
    Join Date
    04-11-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    92

    PIVOT Table on Powerpoint

    Hi FOrum!

    Nice to be back and hope all is well. Im finding a little bit of a problem with the following:

    I have a pivot table in my Excel 2010 which I want to show on a Powerpoint and update realtime when I modify the data in Excel (realtime or pressing an "update link button would work). I have tried pasting it an an Excel object and as a link.

    The problem is that I want my Pivot on the powerpoint to resize automatically. For instance when my pivot in my excel grows with more rows, I want my pivot copy in the powerpoint to grow too- right now all I have is a fixed range updating on my powerpoint but additional rows are not captured.

    Any ideas? Thanks
    Reply With QuoteRegister To Reply
  2. 12-13-2014, 12:45 PM #2
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: PIVOT Table on Powerpoint

    Open both Excel and Powerpoint. Select the Pivot Table in Excel and copy it. Go to Powerpoint, Home Tab, Paste Special, Paste Link, Microsoft Excel Worksheet Object.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  3. 12-14-2014, 04:17 PM #3
    jsuarez199
    jsuarez199 is offline
    Registered User
    Join Date
    04-11-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    92

    Re: PIVOT Table on Powerpoint

    Sorry New Doverman but Ive tried that and it wont work. When I do what you say, the pivot table in my powerpoint updates realtime, but still only captures a fixed range of cells (the original size of the pivot table when I first copied it over to powerpoint- but when the pivot grows in the excel the pivot table in powerpoint does not capture it.

    For example my original pivot table is A2:P20- I do what you say. Now I have a pivot in powerpoint linked to this range and as big as this range

    New data comes in, and my pivot in excel is now A2:P40. My pivot updates to the new values but still only captures the new values in A2:P20, not A2:P40.

    Thanks!
    Reply With QuoteRegister To Reply
  4. 12-14-2014, 05:01 PM #4
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: PIVOT Table on Powerpoint

    Now that is strange. I had it mimicking the Excel worksheet Pivot Table. If I find an answer for you I'll get back.
    Reply With QuoteRegister To Reply
  5. 12-14-2014, 05:17 PM #5
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: PIVOT Table on Powerpoint

    It appears that the number of displayed rows in Powerpoint remains constant for the link to Excel. The data will change but the number of rows will not grow. If you reduce the rows in the Excel Pivot Table, you will notice that Powerpoint will reduce the size of the Pivot table but still display the rows that were included in the original link.
    Reply With QuoteRegister To Reply
  6. 12-14-2014, 05:20 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: PIVOT Table on Powerpoint

    This works in Word, and may work in PPT, but it's painful:

    1. Create a dynamic named range for the pivot table.

    2. Copy the pivot table in Excel and Paste-Link in Word.

    3. Do Alt+F9 to show field codes to see something like this:

    { Link Excel.Sheet.12 "C:\\somePath\\someWorkbook.xlsx" "Sheet1!R1C1:R9C2" \a\p }

    4. Edit that to read ...

    { Link Excel.Sheet.12 "C:\\somePath\\someWorkbook.xlsx" "myNamedRange" \a\p }

    Now you're all set in Word, so ...

    5. Copy the field in Word and paste in PowerPoint.

    Does that work?
    Last edited by shg; 12-14-2014 at 05:24 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  7. 12-14-2014, 05:31 PM #7
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: PIVOT Table on Powerpoint

    @shg

    Good one! It has been 20 years since I had to use Powerpoint with links.

    You are right that it is painful.
    Reply With QuoteRegister To Reply
  8. 12-14-2014, 05:38 PM #8
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: PIVOT Table on Powerpoint

    I found no way (in a one-minute search) to show field codes in PowerPoint.
    Reply With QuoteRegister To Reply
  9. 12-25-2014, 04:44 AM #9
    jsuarez199
    jsuarez199 is offline
    Registered User
    Join Date
    04-11-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    92

    Re: PIVOT Table on Powerpoint

    Hi both!

    I am out of the office and unable to use Excel but will try it as soon as I can. I have high hopes for that solution!

    Thanks newdoverman and shg! awesome christmas present

    have a lovely christmas Ill get back to you when I try it
    Reply With QuoteRegister To Reply
  10. 12-30-2014, 12:00 PM #10
    jsuarez199
    jsuarez199 is offline
    Registered User
    Join Date
    04-11-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    92

    Re: PIVOT Table on Powerpoint

    Hi shg!

    Thanks for the help but unfortunately this still wont work. I have copied the entire pivottable into word as a link , modified it like you told me and now it automatically updates whenever i change the excel. However the range is still fixed- the link in word will update but it will keep the original size/range of the original pivot table when I first pasted the link so back to square one...

    any more ideas on this?

    Appreciate the help!

    Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table to PowerPoint
    By srizki in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 11-03-2014, 11:54 AM
  2. Adjusting Pivot Table to Generate grpah then copy and paste graph into PowerPoint
    By flutergirl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2014, 11:36 PM
  3. Pasting an Excel Table into PowerPoint using VBA as a Table, keeping the source formatting
    By RyLH87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2013, 05:21 AM
  4. How to auto update the PowerPoint table when new data entered into Excel table?
    By Mirisage in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-16-2013, 02:58 PM
  5. [SOLVED] Display Pivot Table Chart in Powerpoint
    By wengyee in forum Excel General
    Replies: 1
    Last Post: 03-08-2005, 11:06 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1