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?

Maybe this article can help:

http://sourcedaddy.com/ms-excel/efficiently-pivot-another-workbook-data.html