Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Limitation
Hi,
I am facing problem in terms of row limitation. The number of records entered are 65000, i want to add more reocrds in the same worksheet but excel is not allowing me to do this. Urgent help is required on this. Thank you in advance. Regards, |
#2
|
|||
|
|||
Hi Farhan,
The limitation is 65536. If your records begin to exceed this capacity then perhaps you should consider ways that you can segregate the data amongst more than one worksheet, as each sheet holds the same capacity. On occassions that I need to utilise so many rows, I am inclined to use Access to crunch the data instead. Merely because it doesn't have this limitation, and because I find performance is better as Excel begins to respond slowly on my PC with so much data within it. Hope this helps, Jon "Farhan" wrote: Hi, I am facing problem in terms of row limitation. The number of records entered are 65000, i want to add more reocrds in the same worksheet but excel is not allowing me to do this. Urgent help is required on this. Thank you in advance. Regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
excel workbook limitation | Excel Discussion (Misc queries) | |||
EXCEL SHARED user count limitation | Setting up and Configuration of Excel | |||
Limitation of Autofiltr option in Excel | Excel Worksheet Functions |