Consulting

Results 1 to 2 of 2

Thread: How to have excel add any new data in a pivot automatically

  1. #1

    How to have excel add any new data in a pivot automatically

    Good Morning, I have one of those weird excel things, I update data from a database and then refresh excel pivot tables. For example, when I refresh I have more dates added whic show as unchecked in the pivot and therefore have to check the date in the pivot and add them to the table. I have multiple tables and as you can imagine it would save time to have it on each refresh. Any thoughts?


    thanks!
    tea

  2. #2
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,597
    Location
    I take it you have filtered that field, in which case in the filtering dialog there is an option at the bottom to automatically include new items, which you should check.
    Be as you wish to seem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •