Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row limit on external data in Excel 2007
I can only get 65,356 rows when I link Excel to an external data source. I am
using an ODBC driver to link to an IBM i-series database (AS400). The database has 167,000+ rows. I thought Excel 2007 had a row limit of 1mil+. Is there different limit for linked tables? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row limit on external data in Excel 2007
Hi Sean
it sounds as though you started from an xls file, which would have been loaded in compatibility mode. Save the file as an xlsx 2007 fileCloseRe-open and you should be able to access all 1 million+rows -- Regards Roger Govier "Sean" wrote in message ... I can only get 65,356 rows when I link Excel to an external data source. I am using an ODBC driver to link to an IBM i-series database (AS400). The database has 167,000+ rows. I thought Excel 2007 had a row limit of 1mil+. Is there different limit for linked tables? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row limit on external data in Excel 2007
Check to see that the worksheet has more than 65k rows. If not, save as
..xlsmexit filereopen. -- Don Guillett Microsoft MVP Excel SalesAid Software "Sean" wrote in message ... I can only get 65,356 rows when I link Excel to an external data source. I am using an ODBC driver to link to an IBM i-series database (AS400). The database has 167,000+ rows. I thought Excel 2007 had a row limit of 1mil+. Is there different limit for linked tables? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row limit on external data in Excel 2007
I suspect your driver doesn't know about Excel 2007. What to do about that
I don't know. -- Jim "Sean" wrote in message ... I can only get 65,356 rows when I link Excel to an external data source. I am using an ODBC driver to link to an IBM i-series database (AS400). The database has 167,000+ rows. I thought Excel 2007 had a row limit of 1mil+. Is there different limit for linked tables? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row limit on external data in Excel 2007
I tried to save as an xlsx file but when I opened it up it still had 65356
rows. I then changed the file format in the Excel Options to xlsx and then closed and reopened Excel. I then started over by re-importing the original file. I guess once you open Excel, it does not care if you change the extension when you save it. Regardless, i was able to get all my rows. Thanks Roger for putting me on the right track!! "Roger Govier" wrote: Hi Sean it sounds as though you started from an xls file, which would have been loaded in compatibility mode. Save the file as an xlsx 2007 fileCloseRe-open and you should be able to access all 1 million+rows -- Regards Roger Govier "Sean" wrote in message ... I can only get 65,356 rows when I link Excel to an external data source. I am using an ODBC driver to link to an IBM i-series database (AS400). The database has 167,000+ rows. I thought Excel 2007 had a row limit of 1mil+. Is there different limit for linked tables? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External data (CSV) and table styles (excel 2007) | Excel Discussion (Misc queries) | |||
How do I Track changes with external data in excel 2007? | Excel Discussion (Misc queries) | |||
External Data Tracking in Excel 2007? | Excel Discussion (Misc queries) | |||
Excel 2007 and External Data Sources | Excel Discussion (Misc queries) | |||
Excel 2007 external data query | Excel Discussion (Misc queries) |