Hi Satya
Excel can think that the usedrange is bigger then it is.
You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:
1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete
And then for the columns
1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete
Save the file an close it
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"Satya" wrote in message ...
Hi,
i am reading data from database and saving it to excel
file. but size of the file is very huge 25 mb and when i
copy the data from excel and paste it to a new excel file
then size of the new file mearly 6 mb. what is the reason?