override old format
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. |
override old format
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" wrote: 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. |
override old format
DOH! man do I hate Homer Simpson.... but he has such a perfect way of stating
the recognition..... so it does..... Thanks Paul. "Paul Mathews" wrote: 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" wrote: 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. |
All times are GMT +1. The time now is 03:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com