I have created an Excel 2007 which has 5 pivot tables with a common data
source in another sheet within the same file. The data source is of only 500
rows or so with about 15 columns (i.e. not particularly large).

However while specifying the data source at the time of pivot table creation
I have inadvertently specified the source range extending to Row 16000 or so
in all the 5 pivot tables

This resulted in making the file size huge - about 9 MB.

However now even after modifying the data source range to only 500 rows -
the file size has not reduced.

Is there anyway I can fix this.

Thanks for your help.