BEx Analyzer exceeding result

Hi Gurus,

Current we have some workbooks having execution issue in BEx 7.x. The workbooks output is very lengthy around 50K rows and 180 cols. When we execute, it is throwing a "client out of memory" issue. When I escalate this to SAP, the answer is to reduce the no of cells to <750,000. At the moment based on my users requirement I cannot do that. I had to use Analyzer only due to the Excel pivot is using on top of it. Is there any idea we can execute these workbooks and use excel pivot table features.

Regards

RS