| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
expand number of rows from limit of 65,536?
I need to bring in data that exceeds the limit of 65,536 rows. Does anyone
know how to expand this limitation? |
|
#2
|
|||
|
|||
|
You can't, that is the limit. You could either use multiple worksheets, or
another product. -- HTH RP (remove nothere from the email address if mailing direct) "Niner" wrote in message ... I need to bring in data that exceeds the limit of 65,536 rows. Does anyone know how to expand this limitation? |
|
#3
|
|||
|
|||
|
If you have it, consider MS Access as the repository for your data, then use
Excel's ability to query an external database to pull in subsets of data on which to do your analysis. "Niner" wrote: I need to bring in data that exceeds the limit of 65,536 rows. Does anyone know how to expand this limitation? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I increase the limit on the number of import rows in Excel | Excel Discussion (Misc queries) | |||
| the limit on how many rows can be in one spreadsheet | Excel Worksheet Functions | |||
| Increase rows in worksheet beyond 65,536 row limit | Excel Discussion (Misc queries) | |||
| How do I limit number of rows and columns on a spreadsheet | New Users to Excel | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Hybrid Mode
