Hi All,

I have a workbook into which l import a bunch of data. The objective
is to then construct a data source for a specific pivot table.

Running the code to import all the data & construct the data source
takes approx 5 minutes without the pivot table.

Running the same code with the pivot table present takes 20 minutes
(got fed up & cancelled)

I have done all the usual things, turned off autocalc, screen updating
etc.

If l delete the sheet containing the pivot table and re-run the code
it returns to approx 5 minutes.

Is there some sort 'autocalc' within the pivot table that needs
turning off?

All help gratefully appreciated

Regards

Michael