Why is this file so large?

[dheida]

Got a time sheet file from one of our supervisors that is 14Mb. There are about 15 sheets with about 100 rows by 20 columns of data. There is some color and borders and some simple formulas for adding up time. I copied just one of the sheets into a new book and saved it and sure enough, it was about 750Kb. So, I deleted all the data in the sheet, saved it, and it is still 500Kb. I then did some paste specials only pasting certain things, and when I did "All Except Borders" the file size was as would be expected. Then I manually put the borders back in the small file and it stayed small. So, the main question, why are these borders causing the files to be so big? And second, why when I delete everything out of the sheet does the file stay big? Hopefully you can understand all that, thanks.

 

[Datsmart]

I would bet that someone formated entire columns or rows, that really bloats a file's size.
Some suggestions to keep file size down and reduce workbook slow-down.
Avoid the following:
Formats that extend over entire Columns, (65536 rows) or entire Rows, (256 columns).
Graphics, even if they are hidden.
Formulae that reference entire rows or columns.
Named ranges that are referenced from worksheets other than their own.

 

[dheida]

I understand what you're saying but I even tried copying just the cells that had data in them (not all row/columns) and it would be large unless I didn't paste the borders.

 

[Datsmart]

What kind of borders are you talking about?
Is it just a simple line around a range of cells or what?

 

[dheida]

What kind of borders are you talking about?
Is it just a simple line around a range of cells or what?

Yes, thin lines between cells and thick lines separating large sections and the entire 100x20 section.

 

[Datsmart]

Those sound like they might be graphics rather than simple cell borders. Like I mentioned in my first post, graphics can bload file size quickly.