Thanks for the reply. Unfortunately the solution is not there. I don't use
OLAP. The data is in the same workbook. There are many pivot tables and when
I refresh them all (one by one), eventually the whole thing freezes. Only
solution I have found is to save as I go along but it is tedious doing that,
and time consuming.
--
Many thanks
Jimbo


"Jimbo" wrote:

I have many pivot tables off a large database and they periodically freeze
when I refresh the data. Only solution is to crash out. Any ideas, comments,
solutions out there. The machine has been checked out OK. I work on a network
- checked out OK.