My refresh all has decided it want to take a l o n g time to complete its task.

I have eight pivot tables taking data from one data file which contains 156 Excel files (each contains data from one of our businesses over the past 15 months).

Of late it seems to be working very slowly - spending a long time "contacting the datasource" before whizzing through the actual update.

Any ideas how to speed the process?

There are 80 queries and 0 connections in the "queries and connections" area which appears on the right of the screen.

Thanks  in advance

Regards

Chris