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.
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.
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.