+ Reply to Thread
Results 1 to 2 of 2

Change table length when the pivot changes

  1. #1
    Registered User
    Join Date
    02-11-2020
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    1

    Change table length when the pivot changes

    Hi all,

    I have i question i hope you can assist me with.

    I need to make a table dynamic, so it changes simultaneously with my pivot-table.

    On the attached picture you can see what i need help with. Every week the length of my pivot changes and i therefore, need help with a function that dynamic changes the range of the table on the left (hours row), so it matches the length in the pivot.

    Is this possible?

    Thanks in advance.

    Annotation 2020-02-11 160536.png

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Change table length when the pivot changes

    Hi and welcome
    why not use an XL table as Data Source ? https://www.excelcampus.com/pivot-ta...e-pivot-table/

    Edit : And you can refresh the PT automatically https://support.office.com/en-us/art...6-8B6568CA9BE2

+ 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: 07-29-2015, 05:19 PM
  2. Replies: 1
    Last Post: 07-29-2015, 05:15 PM
  3. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  4. Possible to link Table length to Pivot table length?
    By saber0091 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-04-2013, 05:36 PM
  5. find field length in pivot table
    By hugo_hand in forum Excel General
    Replies: 4
    Last Post: 08-15-2010, 01:51 PM
  6. Pivot Table Character/Text length
    By sachinattri in forum Excel General
    Replies: 1
    Last Post: 06-01-2008, 09:49 PM
  7. Pivot Table Character/Text length
    By sachinattri in forum Excel General
    Replies: 1
    Last Post: 05-27-2008, 07:09 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