| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I surpass/modify the Excel limit of 65k rows?
I need to open a document in Excel which exceeds the 65k row maximum per
worksheet. The information is in a dif extension, and not xls. Is there a way to bypass or expand the 65k row maximum OR open the data on multiple worksheets? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I surpass/modify the Excel limit of 65k rows?
"Jacob" wrote: I need to open a document in Excel which exceeds the 65k row maximum per worksheet. The information is in a dif extension, and not xls. Is there a way to bypass or expand the 65k row maximum OR open the data on multiple worksheets? Thanks. You might be able to do this in Access, and run queries to split the data and move it into Excel. Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| # of Rows Handled By Excel | Excel Discussion (Misc queries) | |||
| change excel row height without showing hidden rows | Excel Worksheet Functions | |||
| Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
| Is there a limit to the number of rows that can be filtered | Excel Worksheet Functions | |||
| How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
