Macro not updating Pivot Table and Chart every time

Attached has list of daily Sales of five Products in Cols A - C, summarised in a Pivot Table and presented as a Column Pivot Graph.

Macro should clear the existing values in Col C, pause for two seconds (for demo purposes so End user can see the change), create a new list of random numbers in Col C, refresh the Pivot Table and Pivot Graph, wait another two seconds, then repeat the process twice more.

First cycle refreshes Table and Graph perfectly.
Second cycle does not refresh the Pivot at all, but refreshes the Graph when the second values are cleared from Col C.
Third cycle does not refresh the Pivot table when the third Data set is added, so for several seconds you see the third set of values in Col C, the FIRST set of values still in the Pivot Table, and the SECOND set still showing in the Graph! Table and Graph then refresh after few seconds, and everything matches.

Please Login or Register  to view this content.

All solution, suggestions or alternatives welcome as ever


Ochimus