Pivot Table Freezes
 

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.

Pivot Table Freezes
 

Maybe this is the problem:

XL2000: PivotTable Updated Slowly with OLAP Data Source
http://support.microsoft.com/default.aspx?scid=237469


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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Pivot Table Freezes
 

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.