Excel File Size Observation

  • Thread starter Thread starter tkt_tang
  • Start date Start date
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.
 
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.
 
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.
 
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.
 
Back
Top