Refreshing some Pivots Tables makes Excel stop or crash

[skitout]

Hello,

Am hoping there are some solid Pivot Table (PT) users out there who could give
me a hand on this..



The problems:


1) The main problem: Refreshing some PT's makes Excel stop or crash

2) Additionally, changing the filters in these PT's also makes Excel stop or
crash. Other PT's don't crash Excel when refreshed, but do crash Excel when
the
filter is changed... Both sets of Pivot Tables have the same filters...

Further, there are other Pivot Tables in the workbook with the same filters
that
do NOT crash Excel when either refreshing the PT, or changing its filter!

Moreover, for those PT's which can be refreshed without crashing Excel, but
crash it when changing the filter, when we refresh them first we don't
experience problems changing the filter!

And a final problem is that the PT's which exhibit 'problematic' behavior can
change given different data sets.

So I am wondering about whether Pivot Tables are the best way to meet my goal,
which is to dynamically regenerate statistics given a user inputting various
periods (w/ start and stop end dates) out of a large times series of price
data.

General details: my workbook file is currently about 50Mo. There are 52
sheets,
organized around a
main data sheet (raw data + data calculated on this sheet).

There are 112 pivot tables, all linked to the same (internal) source.

Problem 1 occurs with and without the option "Save source data with
file"
of the PT.

For the PT with both problems, I use 2 Values and 2 to 4 "rows" with
filter on 2 of these rows. I use the "Equals" subtype of the
"Labels Filter".

Anybody encounter the same kind of problem or have an idea about the origin of
this? Solution / suggestions appreciated! I also can't find much out there
about


Thanks much in advance,


S.