Dear experts,
My pivot table contain data based on several years. If I record a macro for selecting year item before a given date/year, it gives me this code
''.Please Login or Register to view this content.
HOwever when i run the same recorded macro it gives an error 'Run-time 1004, Unable to get the PivotFields property of the Pivot Table calss', the names and fields are all correct.
Alternatively I am thinking to select them via a loop. Any comments or suggestions
Best Regards
Ali
Bookmarks