flip33
07-04-2005, 07:58 PM
I have tried several options displayed on this website but none have quite done the job. My plan is for users to press a button which will refresh the data (using get external data) and then for a pivot table to be updated displaying monthly FTE figures.
The 'ActiveWorkbook.RefreshAll' function does not appear to be working correctly. When the button is pressed it refreshes the data but not the pivot table. If I then press the button again, it then updates the pivot table.
If anyone is able to help or have any ideas it is greatly appreciated.
Cheers
The 'ActiveWorkbook.RefreshAll' function does not appear to be working correctly. When the button is pressed it refreshes the data but not the pivot table. If I then press the button again, it then updates the pivot table.
If anyone is able to help or have any ideas it is greatly appreciated.
Cheers