override old format

[SteveDB1]

Hi all.
I would like to know if there is a way to over ride the old format
limitations of a workbook.
I've saved the old workbook in the xlsx format. That however doesn't seem to
help at all.

I.e., the old format has a row/column limit. 65K rows, and 200 or so columns.
The new format for 2007 has 1M Rows, and 32k columns.
I've just found that one of my macros to copy a template worksheet into an
older style workbook-- even if I save it as an xlsx format-- does not copy
hte worksheet, and gives me the "cannot copy into this workbook because the
destination has fewer rows than the source workbook...."
Any ideas?
Thanks.

 

[Paul Mathews]

Hi Steve, after saving the old workbook to xlsx format, close it (it'll still
be in "Compatibility Mode" in the session where you save it from xls to xlsx
format for the first time). Now reopen it in Excel 2007 and you should have
all the rows and columns that Excel 2007 avails.

 

[SteveDB1]

DOH! man do I hate Homer Simpson.... but he has such a perfect way of stating
the recognition.....
so it does.....
Thanks Paul.