+ Reply to Thread
Results 1 to 2 of 2

creating a table that will link to a pivot table and change as the pivot table is changed

  1. #1
    Registered User
    Join Date
    07-29-2015
    Location
    Minneapolis, MN
    MS-Off Ver
    2013
    Posts
    2

    Exclamation creating a table that will link to a pivot table and change as the pivot table is changed

    Hello Everyone,

    Using 2013,

    At work I have been tasked with creating tables that will link to a pivot table and change as the user manipulates the pivot table. We are looking to try and have a template so anyone can open the template change the pivot tables to show the information for their specific client and then use our "push to powerpoint macro" we created to create a presentation we can show to clients. What we currently have are tables that will change but if extra rows or columns are added in the tables wont change size to accommodate the new data. the simplest way to do this would be some sort of IF statement but then the cell shows a 0 when nothing is in it. Is there a more advanced formula I can put into the cells of a table to reference that will do this or is there a way to build a table to change size? Im fairly decent with excel but this is beyond my skill set. If anyone has an idea im eager to hear it!


    Thank you!
    Last edited by MP6645; 07-29-2015 at 05:05 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: creating a table that will link to a pivot table and change as the pivot table is chan

    Have you researched the GETPIVOTDATA() function? Without knowing what fields are going to be in the pivot it's a little difficult to give you direction.
    Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.

    Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
    If you're happy with an answer given, please click the * under the person's name to boost their reputation.

+ 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: 6
    Last Post: 07-31-2014, 12:56 PM
  2. Pivot table, assigning a cell wo be change the Pivot table filter
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 05:00 PM
  3. Macro Help Needed - Link Pivot Table Filter to Regular Table AutoFilter
    By ycx1129 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2011, 12:54 PM
  4. Pivot table - change data source to another pivot table in 2010
    By thesecretsanta in forum Excel General
    Replies: 4
    Last Post: 04-13-2011, 12:54 PM
  5. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  6. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  7. Change link in pivot table
    By csimon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2006, 11:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1