Hi Farha,
Base on my test, it won’t refreshes the data from the server, it just filters current data (maybe in cache).
I tried set ScreenUpdate to false and set the filters programmatically, but it doesn’t work. As far as I know, there isn’t a property or method in Excel object model that can disable the report refresh when change filters.
Regards
Starain
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click
HERE to participate the survey.