1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

code for Pivot

Discussion in 'VBA Macros' started by Veeru106, Jun 19, 2017.

  1. Veeru106

    Veeru106 Member


    Can we have code where we can refresh Pivot data and also change Month to current in Pivot itself.
    E.g; if previously my pivot belongs to 03/2017 after pasting new data I want my pivot to refresh and change month to 04/2017 as well.

    Thanks in advance
  2. Chihiro

    Chihiro Well-Known Member

    Please upload sample that accurately reflects your data set (while sanitizing data). Also, specify if your PivotTable is based on Exel Table, Range or OLAP based.

    Code will significantly change based on it.
  3. Veeru106

    Veeru106 Member

    File attached....I am using excel table..

    Attached Files:

  4. Veeru106

    Veeru106 Member


    Any update on the above
  5. SirJB7

    SirJB7 Excel R┼Źnin

    Hi, Veeru106!

    Had you made an appointment for a less than 24hs response? Please be patient, I recommend you to read this, if you haven't done it yet, which seems you haven't...

    Where you may find this:
    • Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."
    And this:
    • If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."
    If that's not suitable for you, of course that you can always hire a consultant and agree with him the terms of the response time.

    Personally the comments to bump up non answered threads move me farther away from reading them again. But this is not a general rule, it just happens to me.


Share This Page