when i have one pivot on one sheet, the excel 2007 speed is ok even though the datasource is from another workbook.
However, when i have two pivots [pivot A & pivot B]side by side on one sheet, the sheet becomes slow and the screen update slows down. when i scroll down for example, it takes time.
The datasource of A is linked to another workbook which is called datasourceA.xls
The datasource of B is linked to another workbook which is called datasourceB.xls
Both datasource have formulas in columns for the entire row.
is there any way i can improve the performance when i have two pivots on one sheet?
However, when i have two pivots [pivot A & pivot B]side by side on one sheet, the sheet becomes slow and the screen update slows down. when i scroll down for example, it takes time.
The datasource of A is linked to another workbook which is called datasourceA.xls
The datasource of B is linked to another workbook which is called datasourceB.xls
Both datasource have formulas in columns for the entire row.
is there any way i can improve the performance when i have two pivots on one sheet?
