| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
To many rows for EXCEL to handle
I have a file with over 70'000 rows in (MS EXCEL only holds around 65'000). Is there any way I can still perform a lookup on this file. The file is saved as a CSV. Please dont tell me to open it in Wordpad and do a search as I have been told this is not acceptable. (Pains). PLEASE HELP ME -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=466216 |
|
#2
|
|||
|
|||
|
Split it into smaller pieces and import each piece into its own worksheet...
Or don't use excel--maybe Access??? moglione1 wrote: I have a file with over 70'000 rows in (MS EXCEL only holds around 65'000). Is there any way I can still perform a lookup on this file. The file is saved as a CSV. Please dont tell me to open it in Wordpad and do a search as I have been told this is not acceptable. (Pains). PLEASE HELP ME -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=466216 -- Dave Peterson |
|
#3
|
|||
|
|||
|
Hi Moglione1,
I have a file with over 70'000 rows in (MS EXCEL only holds around 65'000). Is there any way I can still perform a lookup on this file. The file is saved as a CSV. Please dont tell me to open it in Wordpad and do a search as I have been told this is not acceptable. (Pains). Yes, try Data, Get external data, New database query and follow instructions from there. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
|
#4
|
|||
|
|||
|
The Excel limit is not flexible. You can either break your data into 2 or more sheets or use a Database. Sorry. -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=466216 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
Linear Mode
