File Size

  • Thread starter Thread starter Abdul
  • Start date Start date
A

Abdul

Hi
I am using a file in which i copied the IF formulas till row# 900, an
columns are covered till "BL" and most of them contain IF formulas.

The problem is that file is very huge around 4.000KB.

Because of this i am unable to mail it most of the times.

How can i reduce file size?

Jabee
 
Hi Abdul!

You might reduce the size by ensuring an efficient used range

Go to the first empty row after your data:
Hold down Shift then press End > Down arrow
(Pointing to the selected area) Right Click > Delete

Go to the first empty column after your data:
Hold down Shift then press End > Right Arrow
(Pointing to the selected area) Right Click > Delete

Now save.

Any one off formulas should be converted using copy > paste special >
values > OK

Also try using WinZip. You get an unlimited free trial period.

You'll find that WinZip will reduce file size quite a lot (and
incidentally the file size is reduced even more if you've ensured an
efficient used range as above).

You might consider breaking up the workbook into different workbooks.

And see:
Charles Williams
http://www.decisionmodels.com/optspeedd.htm#Size
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thank you BrainB and Norman,

But i dont want to use WinZip. Norman! I dindnot get the working ide
of "Efficient used range", will you please define it in a bit mor
detail so that i can use it?

Thanks to u all once again.

Jabee
 
Hi Jabeer!

If you have data in A1:D200 and nothing anywhere else, then that is
your used range. However, Excel often gets the used range outside this
due to formatting or "historic" reasons. When the file is saved, the
file size is a function of the used range. If you tidy up the used
range by using the process recommended, Excel is only going to have to
record data on the cells in that range and it could mean that the file
size is a lot smaller.

Tidying up the macros, if any, will also have the same result.

I know that you're not interested in Winzip but others might be
curious to know that there are a two tricks for reducing WinZip size.
First is to make the used range efficient and the second is that a
Winzip file size is a lot less if the file is saved with no protection
on the sheets. Just whack in an opening subroutine that imposes the
worksheet protect.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thank you Norman for your quick response.

It helped me a lot. In addition I have designed a macro for generatin
report and another to delete that report.

Thanks

Jabee
 
Hi Jabeer!

Always pleased to help. Never hesitate to ask for explanations.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
If the recepients don't have to see the formulas, then
what I'd do is copy everything and paste back just the
values with "paste special".
 
Back
Top