Excel file Size

[Guest]

we have office 2003.
An normal excel sheet which have 1.02 MB size but if i copy the matter of
the file into new file it gives 15 kb size.
My question is that
Why same data in excel file but files are of different size?
both the files saved as Microsoft office Excel Workbook.
why it is creating so heavy file of 1.02 mb.
please give the e-mail address i will send you the file as attachment. so
that you can check the actual file.

thanks
rana adnan
(e-mail address removed)

 

[Jim Rech]

please give the e-mail address

This is a user-to-user support group. No official MS representation here
must of the time.

I'd guess different formatting may be the cause although it could be any
manner of things. If you press Ctrl-End you'll be taken to the last active
cell on the current sheet. Do this on each sheet and you may find one or
more sheets have huge active areas that in turn makes huge files.

--
Jim
| we have office 2003.
| An normal excel sheet which have 1.02 MB size but if i copy the matter of
| the file into new file it gives 15 kb size.
| My question is that
| Why same data in excel file but files are of different size?
| both the files saved as Microsoft office Excel Workbook.
| why it is creating so heavy file of 1.02 mb.
| please give the e-mail address i will send you the file as attachment. so
| that you can check the actual file.
|
| thanks
| rana adnan
| (e-mail address removed)
|

 

[Guest]

A couple of possibilities:

1) If you're copying only values to the new spreadsheet, then you're
ignoring any underlying formulas, macros, objects, etc., all of which
increase file size.

2) The used range of the original spreadsheet is greater than you think it
is. To test this, go to the original spreadsheet, hit CTRL+END and see where
XL jumps to. If it's beyond what you think is the end of your spreadsheet,
then XL somehow has chosen a used range greater than what you think is used.
Delete everything to the right and below what you think is the used range,
save, close, and re-open the workbook.

Dave