want to limit worksheet to 1000 rows instead of 65,000
All (pre-XL07) worksheets have 65536 rows. That can't be changed.
However, unused rows don't take up any memory or disk space, so there's
no need to try to limit them.
What problems are you having?
In article ,
GeoObject wrote:
My worksheets only need 1000 rows but the worksheet remains at 65,000+ rows.
I have 1 GB or ram and 6 worksheets causes problems. How can I set a default
to limit the max number of rows and columns.
Thank you
|