Trouble Shoot in Refresh

Hi Guys

I have to right click on the date and do the refresh. But i am not able to do that



1 Like

Kindly try with macros
—for that record the macros and copy that vb script and paste it in a text file
—then use INVOKE VBA and execute the same macro by placing this activity inside the excel application scope

Kindly try this and let know for any queries or clarification
Cheers @Kamesh

Hi Palani

Thanks for the reply I am not using macro or VB script using Pivot table. In One sheet i will be entering the data and in the other I am just refreshing the data and getting the chart for required date


the reason why suggested MACRO is we wont be able to click on the Date column alone with the click activity as it will select the whole table structure as element
Thats why, buddy
Cheers @Kamesh