Bezar

K

Khalil Handal

Hi,
I have a workbook size of file is 17 MB. It contains 16000 rows, 5 colomns
had simple formulas copyed down accross to 16000 rows.
All the cells in the shhet have borders 56000 row. I selected the rows
between 16200 and 65000 and Edit>Clear>all
to erase the borders that are not neccessary so as i will have a smaller
size of file. When saving the file its size encreased to 30 MB.
Any Ideas?
 
J

Joerg

Delete rows 16200 to 65000 (clearing the cell contents is not enough). Do
the same for all unnecessary columns to the right of your used 5 columns. I
bet this will decrease the filesize. Let me know if I lost my bet...

Cheers,

Joerg
 
A

Adel Handal

Hi Joerg,
I cleared the contents and deleted the rows and colomns.
Gues what!
The size of the file became 29.6 MB
Sorry to disappoint you!
 
J

Joerg

Yes, you do disappoint me!

1) Just to confirm: Ctrl+End jumps to the lower right cell of your actually
used range, not any further?
2) Would it be an option to copy the data to a "fresh" workbook? Somehow
Excel seems to have saved a previous version of your workbook together with
the present, resulting in a 100% size increase.


Cheers,

Joerg





that your worksheet does not include unnecessarily saved ranges, you could
go to the macro editor (Alt+F11), and type into the Immediate Window (if not
visible, make it visible with Ctrl+G) the command "print
activesheet.usedrange.address" (without quotes) and press Enter. The
 
A

Adel Handal

Hi again,
1) Just to confirm: Ctrl+End jumps to the lower right cell of your
actually used range, not any further? YES
2) Would it be an option to copy the data to a "fresh" workbook? Somehow
Excel seems to have saved a previous version of your workbook together
with the present, resulting in a 100% size increase.
Click to expand...

after pressing Ctrl+End I pressed: Shift+Ctrl+Home to select the range of
cells then: COPY go to new sheet in new workbook and PASTE.
I have done this for the 6 Sheets I have. The saved the newbook and the size
was exactly 29.6 MB

Any other suggestion!!!
 
D

Don Guillett

After DELETING your un-desired rows and columns by using the row/column
indicator>SAVE.
 
J

Joerg

Check if one of your 6 sheets is the culprit: Reduce your workbook to one
sheet and save. Repeat this with every sheet.
Let me guess: Size does not decrease to 5MB as one would expect, but you
should give it a try.

We haven't looked at your "simple" formulas. Excel internally stores formula
results so that it doesn't have to recalculate everything each time a
workbook is opened. Depending on the formula this can result in a huge file
size. What does your formulas look like?

Other ideas:
1) "Track changes" is on?
2) You use external links?
3) You use pivot tables?

Joerg
 
A

Adel Handal

Thanks.
I will try it when I go home.

Joerg said:
Check if one of your 6 sheets is the culprit: Reduce your workbook to one
sheet and save. Repeat this with every sheet.
Let me guess: Size does not decrease to 5MB as one would expect, but you
should give it a try.

We haven't looked at your "simple" formulas. Excel internally stores
formula results so that it doesn't have to recalculate everything each
time a workbook is opened. Depending on the formula this can result in a
huge file size. What does your formulas look like?

Other ideas:
1) "Track changes" is on?
2) You use external links?
3) You use pivot tables?

Joerg
Click to expand...
 
A

Adel Handal

Hi,
Thank you for the effort to help.
"track changes" is off.
No links.
no pivot tables.

I tried saving each sheet alone and ahve also large files. Sheeet4 is 8.5 MB
alone and the others are about 3 5 MB Each.
following is 7 out of 9 of the formulas in sheet4 and each formula is copyed
to downward until line 16000.

=H10+E11-F11-G11
=P9+M10-N10-O10
=X8+U9-V9-W9
=AF10+AC11-AD11-AE11
=AN10+AK11-AL11-AM11
=AV9+AS10-AT10-AU10
=BD9+BA10-BB10-BC10
Note: the file is about calculating what item are left in a wood store after
selling any of the materials.
 
J

Joerg

I've just sent you a mail to your reply address. Maybe we can sort this out
offline and post solutions (if any) afterwards.

Cheers,

Joerg
 
Top