Excess blank rows below pivot table

[Rex Stetson]

I created a pivot table that generated around 35,000 pivot table rows. I then greatly reduced the data and refreshed the pivot table so that it only generated around 200 rows. However, it looks like the 34,800 unused rows below the pivot table are still somehow allocated by the pivot table. I'm unable to delete these blank rows and I'm pretty sure they're the reason the file size is over 2 mb.

When I added more data and refreshed the pivot table to a size of 39,000 rows and then reduced it back down to 200 rows, there were then 38,800 blank rows below the pivot table which I couldn't delete and the file size grew larger.

Is there any way to delete the unused rows below the pivot table to reduce the size of the file, if that's really what's causing the problem?

 

[PCL]

Perhaps try:
Select all empty rows
Edit Delete
Save your file
Quit Excel ( rows are completely removed when shuting down EXCEL)
Launch Excel
read your file

 

[Rex Stetson]

Selecting the rows and deleting does nothing. I scroll to the bottom and the last row is 35561. If I select 2000 rows, click delete, scroll to the bottom, the last row is still 35561. Saving the file does not remove them either.

 

[Rex Stetson]

I take that back. Although I thought I did that several times, deleting lines and then opening the file back up did remove the lines. Thanks.