Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

I have two excel files that are exactly the same (in terms of the content of the file) but differ by quite a margin on filesize. One file is 37.5Kb while the other is 56Kb. The only difference I can see is the filename's. I don't know why there is such a big difference. Is there some sort of history or something that is stored with the file that is not visible to the user? If so, how would you delete this?

Thanks for your help.

share|improve this question
Are your files on the same filesystem? If they are on different filesystems that don't have the same block size, that might be the reason. – vtest Oct 22 '10 at 13:12

migrated from stackoverflow.com Oct 22 '10 at 12:54

4 Answers

up vote 0 down vote

Yes, the Office applications keep all kinds of junk besides the current contents of the document. You can clean up the file with the Remove Hidden Data Add-in.

share|improve this answer
up vote 0 down vote

Try creating a new, empty .xls file, copy the data you want from a larger file, and paste it into the new one.

share|improve this answer
It's not about the data, I wanted to know why there was such a big difference in file size and what was causing it. The formatting of both spreadsheets is exactly the same. – meme Aug 19 '10 at 15:57
well, as others have said, Excel does not optimize itself continuously for file size, as you're seeing. There's more to an .xls file than data and formatting. – Beth Aug 19 '10 at 16:18
up vote 0 down vote

Excel files can become 'fragmented' with constant editing. If you want to reduce the file size to a minimum, look at the following:

http://www.ehow.com/how_2252595_reduce-size-excel-files.html

share|improve this answer
up vote 0 down vote

Excel does have a "Track Changes" feature under Tools/Track Changes on the menu bar; although it only keeps change records for a default of 30 days.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.