Hi All,

Yes l could delete the pivot table and rebuild with code but that
seems to be very inelegant.

It seems to me that the pivot table is 'constantly' attached to the
data source and even with auto calc set to manual wants to refresh
each time a cell in the data source is changed. It seems inconceivable
that this cant be turned off somehow?

Barb - The code to import the data is massive and does not refer to
the pivot table in any way, however it does delete the pivot table
data source range and re-builds it, hence my comments above. The data
source range is approx 15000 rows by 65 columns and requires lots of
loops & lookups, hence the 5 minutes running time. I am currently
looking at ways of reducing this but time restraints neccesitate that
l at least get an operating version of this quickly (like today!)

I really would appreciate any help on this as l am under pressure to
get this working quickly.

Regards

Michael