Results 1 to 4 of 4

Pivot table refresh - VBA Code

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    16

    Pivot table refresh - VBA Code

    Dear friends,
    I have a pivot table and what i need is everytime when the new data is added, the pivot table to should get refreshed with all the filter selected (including blanks) in every filter.
    Currently the issue is, whenever i add a new data (fruits / dealer / stage / Total quantity) the item in the pivot filter which is comes after Blanks doesnt get selected.

    Attached the spreadsheet for your help.

    Thanks in advance
    Attached Files Attached Files

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