Change in File size

K

Khalil Handal

Hi,
One workbook has 4 sheets size of file is approxiamtly 1 MB
after erasing 3 sheets and saving the size of file with one sheet (tables-1
left) is 744 KB only
I then copy that sheet (tables-1) to another workbook that has other sheets
the size of the whole workbook was only 490 KB.

Is there a reason for this?
Actually this happens a lot with me. When I copy on sheet from one open
workbook to another open workbook the size of the file copyed to goes up to
3 times larger in size. Can any one help ?
 
C

Craig Coope

Hi,
One workbook has 4 sheets size of file is approxiamtly 1 MB
after erasing 3 sheets and saving the size of file with one sheet (tables-1
left) is 744 KB only
I then copy that sheet (tables-1) to another workbook that has other sheets
the size of the whole workbook was only 490 KB.

Is there a reason for this?
Actually this happens a lot with me. When I copy on sheet from one open
workbook to another open workbook the size of the file copyed to goes up to
3 times larger in size. Can any one help ?
Click to expand...

I myself have just noticed something like this. Actually I have not
been copying from sheet to sheet but I have just finished a sheet with
a few forms and it was about 700k when done...but now when I look it
is about 440k on a different machine...I'm very confused...at first I
thought it was the unfinished version!
 
J

Jim Cone

This may help...
http://www.contextures.on.ca/xlfaqApp.html#Unused
"File Size - large" (Debra Dalgleish)

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
Excel add-ins (free and for sale)



"Khalil Handal"
<[email protected]>
wrote in message
Hi,
One workbook has 4 sheets size of file is approxiamtly 1 MB
after erasing 3 sheets and saving the size of file with one sheet (tables-1
left) is 744 KB only
I then copy that sheet (tables-1) to another workbook that has other sheets
the size of the whole workbook was only 490 KB.
Is there a reason for this?
Actually this happens a lot with me. When I copy on sheet from one open
workbook to another open workbook the size of the file copyed to goes up to
3 times larger in size. Can any one help ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel, assign cells in multiple worksheets from one sheet 1
Why is my empty Excel workbook 2/3 MB in size? 6
Macro executing (copy data) from at sett of sheets in the workbook 3
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21
Please help with code! Thanks! 1
Pivot table caused 50 MB excel file 5
Get Name of Sheet to use in Macro 11
Copy Data from One sheet to Different Sheets 1

Top