Excel File Size Observation

T

tkt_tang

1. Enters an Excel workbook A sized 2500 kB ; it contains a single
worksheet B.

2. Create a copy of worksheet B called worksheet C.

3. Save the workbook and MS-IE indicates that the file is then sized
5000 kB.

4. Clear the worksheet C (of the used range). Now, worksheet C is
discernibly blank.

5. Save the workbook and MS-IE indicates that the file is (still) sized
5000 kB.

6. Please advise what has happened such that the file size once
increased, could not be correspondingly reduced.

7. Regards.
 
T

tkt_tang

1. After applying Debra Dalgleish's method, the Last Cell of the
worksheet (B) is located correctly.

2. However, the file size (accountable or not-so-accountable) remains
unchanged.

3. regards.
 
N

Norman Jones

Hi Tkt,

And, to add to Biff's comment, depending on the version of Excel you are
using, you may need to save | close | re-open -as suggested by Debra in
point 4 of her suggested manual process.
 
T

tkt_tang

For the accountable and not-so-accountable file size, would like to
provide the following statistics :

1. Workbook A commences with 2489 kB (that's worksheet B alone).

2. After adding worksheet C (that's a mere copy of worksheet B), it
becomes 4978 kB.

3. Clear out worksheet C ; it becomes 4918 kB. Deduce that the
discernible solids (and hence the accountable ones) in worksheet C are
merely 60 kB.

3a. The given figures are confirmed after Save-and-ReSave of the
workbook etc.

4. After applying Debra Dalgleish's method, the Last Cell of the
worksheet (C) is located at A1 (via pressing keys Control+End).

5. To avoid any confusion that may arise ; the previous round figures
of 2500 and 5000 kB are quoted for the sake of convenient
communications.

6. Regards.
 
Top