Harald Staff;355753 Wrote:
If it is an existing xls file, save as xlsx or xlsm in Excel 2007. Close
and
reopen, and it should have lots of fresh new rows and columns.

HTH. Best wishes Harald


"John McCabe" wrote in message
ng.com...
Was trying to show how 2007 will go to 1 mill rows. Can do it open

new
BLANK worksheet.
How can I do it if the worksheet is already existing and just want to
show
HOW it can go to more rows than will ever need.


The number of rows and coluimns remains constant, what do you mean by
new?


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99812