workbook size

From: Pete McCosh (Pete_at_Mc.Cosh)
Date: 05/19/04 

Date: Wed, 19 May 2004 07:40:52 -0700

Judith,

if your empty rows all have some kind of formatting then
it's probably taking up quite a bit of memory. To get rid
of some of this dead space, go to the last row of actual
data on the ***, select the entire row for all the rows
beneath this and delete them all. Repeat the same for
columns to the right of your data.

Now save the workbook. If you check the properties, you
should notice a reduction in the size of the file and, if
not, at least your scroll bars will be back to normal!

Cheers, Pete.

>-----Original Message-----
>I have a workbook with VBA macros attached. It is now
>huge in terms of rows and article 211888 suggests that
>this is due to using the VBA editor and suggests deleting
>unused sheets.
>
>On the sheets I am using I have thousands of rows while I
>am only using a few hundred. This means that a slight
>nudge on the scroll bar putting me into outerspace. Is
>this just something I have to live with? Maybe I will
>have to develop a more delicate mouse action!
>.
>