Pivot Table with more than 1000 rows

I have built a Pivot table by using “Workshop”. The result is good but it only can export 1000 rows. Anyway to allow export more than 1000 rows?