Large Pivot Refresh problem Excel 2003

J

Jon Sebright

I have a large spreadsheet which contains a large pivot
table (183R * 19C) -based on a largish data set (2730R *
11C).
I am unable to refresh this pivot table in Excel 2003 - I
get error message "There are too many records to complete
this operation." The spreadsheet refreshes fine under
Excel 2002 - why not on 2003?

Is this a known problem / is there a workaround (I cannot
reduce the size of the table).

Jon.
 
Top