row limits excel 2007 restricting pivot table calculations

[Jazz]

External data source is causing the pivot table to run out of rows while
calculating in the background, before showing what should be a small pivot
table. Data source is Olap query?

Do I have any options?