Hi,

On a worksheet I am using the first 69 rows and the first 55 columns.
Everything was fine until I unlocked a range of 31 columns.

Following guidelines from the group a couple of days ago, I unlocked the
entire columns.
This resulted in the file size increasing from 240 kb to 1.57 mb, with the
used range covering the entire worksheet. (The sheet referred to is a
template and a further 11 copies are to be added - I hate to think about the
resultant file size!)

I have cleared and deleted then unused columns which changed the used range
to cover the used columns, although this has not reduced the file size.

I have also in desperation cleared and deleted the unused rows below my
usage, but this has not
made any difference - the used range still covers the entire column range.

Any ideas will be gratefully considered.

Regards,
Don
--

Hi,

Further to my original post I have since repeated the operation of clearing
and deleting the rows below my usage and this resulted in these rows
disppearing entirely (as if hidden) and I can't make them reappear. The file
size however has dropped to 180 kb.

HELP!

regards,
Don

SAVE
if that doesn't work
exit

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Donald Lloyd" wrote in message
...
Hi,

On a worksheet I am using the first 69 rows and the first 55 columns.
Everything was fine until I unlocked a range of 31 columns.

Following guidelines from the group a couple of days ago, I unlocked the
entire columns.
This resulted in the file size increasing from 240 kb to 1.57 mb, with the
used range covering the entire worksheet. (The sheet referred to is a
template and a further 11 copies are to be added - I hate to think about
the
resultant file size!)

I have cleared and deleted then unused columns which changed the used
range
to cover the used columns, although this has not reduced the file size.

I have also in desperation cleared and deleted the unused rows below my
usage, but this has not
made any difference - the used range still covers the entire column range.

Any ideas will be gratefully considered.

Regards,
Don
--

Thanks Don

I've done both.
Don

--

"Don Guillett" wrote in message
...
SAVE
if that doesn't work
exit

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Donald Lloyd" wrote in message
...
Hi,

On a worksheet I am using the first 69 rows and the first 55 columns.
Everything was fine until I unlocked a range of 31 columns.

Following guidelines from the group a couple of days ago, I unlocked the
entire columns.
This resulted in the file size increasing from 240 kb to 1.57 mb, with
the
used range covering the entire worksheet. (The sheet referred to is a
template and a further 11 copies are to be added - I hate to think about
the
resultant file size!)

I have cleared and deleted then unused columns which changed the used
range
to cover the used columns, although this has not reduced the file size.

I have also in desperation cleared and deleted the unused rows below my
usage, but this has not
made any difference - the used range still covers the entire column
range.

Any ideas will be gratefully considered.

Regards,
Don
--