+ Reply to Thread
Results 1 to 4 of 4

change(update) pivot table data source.

  1. #1
    Registered User
    Join Date
    02-09-2012
    Location
    Lithuania, Vilnius
    MS-Off Ver
    Excel 2007
    Posts
    3

    change(update) pivot table data source.

    Hello people,

    I've been googling for about 2 hours without any good results... so hopefully someone can give me a hand.

    I have a Excel file with 2 sheets.
    Sheet(1) has pivot table
    Sheet(2) has the data for that table.

    All I need to do is make some script that would update data source for pivot table. In Sheet(2) only row number can change - column number will remain the same.
    I have found a way to determine row number by using this:
    row_num3 = Application.CountA(Range("C:C"))

    Could someone give me a hand with updating pivot table with new data, when it's being added?

    Thanks a lot!

    BR,
    Modestas

  2. #2
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: change(update) pivot table data source.

    I suggest you use a dynamic range as the data source - see Debra Dalgleish's tip here.
    Good luck.

  3. #3
    Registered User
    Join Date
    02-09-2012
    Location
    Lithuania, Vilnius
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: change(update) pivot table data source.

    That was very usefull. Took a wile at first as I am using Excel 2007, but that was cool.
    Thanks a lot!

  4. #4
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: change(update) pivot table data source.

    My pleasure.

    Please do not forget to mark the thread Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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