I have an excel file that is 153kb in size. When I place my cursor one row
below the last row of data (230) and use the Ctrl+Shift+DownArrow and select
Hide Row to hide all the rows higher than 230 the size of the file increases
to 1.55mb. What causes this to happen
--
Don

Excel then interprets that your file size has just increased from 230
lines to 65,536 (ie the max number of rows) as you have 'done'
something to the remaining rows (ie hidden them). It therefore needs
to record these rows which thus uses storage increasing the file size
(it doesn't record them if they are empty).

Hope this helps!

Richard


Don4908 wrote:
I have an excel file that is 153kb in size. When I place my cursor one row
below the last row of data (230) and use the Ctrl+Shift+DownArrow and select
Hide Row to hide all the rows higher than 230 the size of the file increases
to 1.55mb. What causes this to happen
--
Don

Just to correct what I said - Excel doesn't record them if they have
not been modified in any way (which includes formatting/hidden etc) -
whether or not they actually contain values.


RichardSchollar wrote:
Excel then interprets that your file size has just increased from 230
lines to 65,536 (ie the max number of rows) as you have 'done'
something to the remaining rows (ie hidden them). It therefore needs
to record these rows which thus uses storage increasing the file size
(it doesn't record them if they are empty).

Hope this helps!

Richard


Don4908 wrote:
I have an excel file that is 153kb in size. When I place my cursor one row
below the last row of data (230) and use the Ctrl+Shift+DownArrow and select
Hide Row to hide all the rows higher than 230 the size of the file increases
to 1.55mb. What causes this to happen
--
Don

Richard

Didn't see this post before I wrote the large "NOT" in my post.

Apologies and thanks for re-posting to update OP


Gord

On 19 Dec 2006 13:47:35 -0800, "RichardSchollar"
wrote:

Just to correct what I said - Excel doesn't record them if they have
not been modified in any way (which includes formatting/hidden etc) -
whether or not they actually contain values.


RichardSchollar wrote:
Excel then interprets that your file size has just increased from 230
lines to 65,536 (ie the max number of rows) as you have 'done'
something to the remaining rows (ie hidden them). It therefore needs
to record these rows which thus uses storage increasing the file size
(it doesn't record them if they are empty).

Hope this helps!

Richard


Don4908 wrote:
I have an excel file that is 153kb in size. When I place my cursor one row
below the last row of data (230) and use the Ctrl+Shift+DownArrow and select
Hide Row to hide all the rows higher than 230 the size of the file increases
to 1.55mb. What causes this to happen
--
Don

Why don't you just use scroll lock instead of hiding cells.

Don

Hiding rows and columns will NOT increase the size of your workbook.

You can test this by opening a new workbook and save it untouched.

File size will be about 15k

Hide everything but A1 and re-save.

File size will not change.

You must have something else going on.

Unhide the rows and select A1 then CTRL + End

Where does Excel take you?

For more help on large file sizes see Debra Dalgleish's site

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On 19 Dec 2006 13:28:55 -0800, "RichardSchollar"
wrote:

Excel then interprets that your file size has just increased from 230
lines to 65,536 (ie the max number of rows) as you have 'done'
something to the remaining rows (ie hidden them). It therefore needs
to record these rows which thus uses storage increasing the file size
(it doesn't record them if they are empty).

Hope this helps!

Richard


Don4908 wrote:
I have an excel file that is 153kb in size. When I place my cursor one row
below the last row of data (230) and use the Ctrl+Shift+DownArrow and select
Hide Row to hide all the rows higher than 230 the size of the file increases
to 1.55mb. What causes this to happen
--
Don

Presumably XL has to use all those rows you hide; i.e., it has to "remember"
that those rows are hidden.

Why not just leave the rows visible?
--
Brevity is the soul of wit.


"Don4908" wrote:

I have an excel file that is 153kb in size. When I place my cursor one row
below the last row of data (230) and use the Ctrl+Shift+DownArrow and select
Hide Row to hide all the rows higher than 230 the size of the file increases
to 1.55mb. What causes this to happen
--
Don