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
--
Brevity is the soul of wit.


"Rana Adnan" wrote:

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