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
--