+ Reply to Thread
Results 1 to 1 of 1

Macro to filter pivotitem resulting in incorrect month selection

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    7

    Macro to filter pivotitem resulting in incorrect month selection

    I am having an issue in correcting a pivot which refreshes on running a macro.
    In the attached workbook, the macro named "ref_pivot" is used to refresh the pivot with the tables values and also apply filters to the pivot item.
    What I am trying to achieve is to apply filter to the pivotitem "Org_Sched_Month" to filter for the months from today and before. However it is not selecting the current month and selecting the month of May instead.

    Any help is much appreciated. Macro enabled workbook attached.
    Attached Files Attached Files

+ 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. Filter PivotItem with Formula
    By niya429 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2013, 05:54 PM
  2. [SOLVED] Trying to setup a filter based on Radio button Selection for the month
    By RaulRodriguez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-12-2013, 09:35 AM
  3. Replies: 0
    Last Post: 06-14-2013, 12:33 PM
  4. Multiple criteria arrays in countifs function resulting in incorrect answer
    By laurenmoney in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-28-2013, 12:57 PM
  5. =Month function in Excel gives incorrect month
    By jbmx in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-14-2005, 03:05 PM

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