I have an Excel-related puzzle: what would cause an Excel file with only two sheetsthe first has less than 800 rows of data, the second about 400, both have two columnsand no formatting applied (but with auto filters applied) balloon to 68MB? Any theories?
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Huge Excel file--why?
- Thread starter vawolf
- Start date
- Sort by reaction score
Copy just your data into a new Excel page and tell me if it's still huge. There could be data elsewhere in the file that is somehow taking up massive amounts of space, for some reason. 
vawolf said:
Do you linked charts or graphs in it? If so that will cause Excel to put all the data from the other worksheets into your worksheet as well. Then if those linked sheets have linked sheets in them...well the file can get large rather quickly.
This worked
There must've been extra data that got copies over various versions of the file. I tried your suggestion and it worked. Thanks!
mad jew said:Copy just your data into a new Excel page and tell me if it's still huge. There could be data elsewhere in the file that is somehow taking up massive amounts of space, for some reason.
There must've been extra data that got copies over various versions of the file. I tried your suggestion and it worked. Thanks!
I think this can happen if you have change tracking turned on, basically keeps track of every modification to the file - might be worth checking in case it's still turned on and the files change a lot, you're going to end up in the same situation.vawolf said:
