Excel File size question?

[tdp3290]

I have a workbook (.xls) that I am saving to a web page, and the file is about 28MB. I am trying to figure out how it has gotten so LARGE. It contains 4 sheets with the following rows and columns:

Sheet 1 = 50 Columns x 3000 Rows
Sheet 2 = 25 Columns x 3000 Rows
Sheet 3 = 25 Colums x 100 Rows
Sheet 4 = 25 Column x 500

Is it the number of feilds and columns that is creating this file size? Formulas are very simple.... no pictures etc. etc.

Just curious if anyone can comment....

Thanks....

 

[erik.van.geit]

Hi,

28MB
I would expect less than 1 or 2

some ideas

do a search on the Board for "filesize"
example
http://www.mrexcel.com/board2/viewtopic.php?t=199237
also search for "ExcelDiet"

delete sheets one by one on a copy of the workbook
save after each delete and check the filesize
you'll problably find the "flipping sheet"
in the worst case you'll have to make this one again

tip: save your work often with new names
after some hours of work you can delete the intermediate versions when you see there are no problems

I'm saving this way:
name 050102 1234
name 050102 1242
name 050102 1249
next day
name 050103 0912
name 050103 0924


take a look at the thread REBUILD your workbook

interesting links
http://www.ozgrid.com/Excel/ExcelProblems.htm

if it was me, I would not investigate too much, but rebuild the workbook, which is always very good to clean up anyway

kind regards,
Erik