Hi Arun, Thanks for the reply. Is there any other way for me to auto refresh the pivot in the scheduling process? Thanks, Andy

Hi, I'm looking for a VBA code that will refresh my pivot tables after my report builder requests have finished refreshing, reason being I need the pivot to amend the data for the front end of the dashboard. Can anyone help with a link or a code at all to point me in the right direction? Thanks, And...

Hi Getting a "ping failed" message when trying to log into Ad Hoc Analysis Connection is fine. Any ideas on how to fix?