reducing the file size

[psrs0810]

I have a file that is huge for the amount of data that is in it. 1.283Megs for a file that is 33 rows by 11 columns.
each cell contains various letters, numbers, words.

What would cause this and how can I reduce the file size?

Thank you

 

[Jonmo1]

First, I would'nt call 1.283 MB Huge....

But I would guess Formatting, particularly if you have formatting that extends beyond the actual used Range.

Also perhaps some Conditional formatting, or any other formulas.

 

[psrs0810]

I know 1.283MB is not huge, but for 363 cells it really should be more like 50KB.
when you say formatting beyond the range of acutal cells used - when I open the file how would I know if there is formatting beyone the used range?

Do you have an easy way to clean it up?

Thanks

 

[Jonmo1]

Try this on a copy of your book (just in case)...

Try inserting a new sheet
And from the original sheet, copy the actual used range (11X33) and paste into new sheet
Delete original sheet.

That should at least get rid of any formatting beyond the used range.

 

[psrs0810]

Much better - a manageable 46KB

Thanks

 

[MrKowz]

Also there could be a problem that there are a bunch of shapes on the page... try running:

Public Sub deleteshapes()
ActiveSheet.Shapes.SelectAll
Selection.ShapeRange.Delete
End Sub