Excel Limitation

  • Thread starter Thread starter Farhan
  • Start date Start date
F

Farhan

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,
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exceed Row Limit 4
2007 Data Export Limit 2
How can I limit Access query to 65000 records 4
Combine multiple worksheets in one Workbook into one big worksheet 6
What If a Table has a Million Rows?! 12
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel sheet: selection of cell or rows not visible. 2
Sum Prodcut issue from .txt import 1

Back
Top