Hiding rows doubles workbook size on disc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I have a macro workbook that only uses about 200 rows, but has a lot of
formulae...

On disc it is 1045 KB.

When I hide all the rows between row 200 and the last row the size on disc
goes up to 2045KB

Is there any way to get rid of those rows (so the user just sees a grey
area, non-clickable) without doubling the size of the workjbook on disc...?

It's Excel 2000, on Windows 2000 Pro (Windows 2000 Server network...)

thanks

Philip
 
Philip
I have Excel 2002 and I don't get the size increase that you do. I
think you are doing something to make Excel think the file is bigger than it
is. Do the following:
Let's say your data range is A1:Z200 and you want to hide all other rows
and columns. First you must reset your last cell. Select row 201 by
clicking on the 201 in the column of row numbers. Now do Ctrl-Shift-Down
Arrow. This selects every row from 201 down. Now put your mouse pointer
anywhere in the selected area, right-click, and click on Delete. This
deletes every row from 201 down and replaces all these rows with fresh blank
rows. Now select Column AA. Do Ctrl-Shift-Right Arrow, right-click in the
selected area and click on Delete. This does the same thing for the
columns.
Now to hide the rows and columns. Do the same thing as above but click
on Hide instead of Delete. Save the file and see how big it is. HTH Otto
 
Back
Top