I have created a small excel file, with a pivot table in it. The file only has 15 lines of data. But, when saving it, it takes up 12 meg of space. I looked at the traditional issue, of accidentally using too many rows of data and that is not a problem. Does anyone have any information as to why a small pivot table file would save at 12 meg? Saving Changes...
Sort By:
Elizabeth HarrinDirector| RebelsGuideToPM.comLondon, England, United Kingdom
That doesn't sound right to me. We often use pivot tables in Excel and they are nowhere near as large as that. Have you tried copying the data into a new file and starting again? Saving Changes...
Stuart DixonProject Office Manager| Xl CatlinCrowbrough, United Kingdom
I am assuming that this isn't a shared workbook, which will track all the changes you have made.
Other than that the most common ones are checking that Excel doesn't store the data when saving (an option in the pivot table) or that you have formatted the entire column, rather than just the data you wanted which saves all of the rows rather than just your data.
personally I would go for Elizabeth's choice of start again. Saving Changes...
As several of you suggested, I ended up copying the information to a new file and rebuilding the pivot table. And, now, it is a more manageable size.
At one time, when the data was not yet entered, looks like someone put some data in row 16,000, and excel thought the datafile was 16,000 rows, even though it was only 200. I tried to copy the data worksheet to another worksheet, to remove the 15,800 extra rows. That worked, but the pivot table file as a whole was still 12 meg.
