Increasing number of records in a work book

  • Thread starter Thread starter M E Ramakrishnan
  • Start date Start date
M

M E Ramakrishnan

I want to view an excel sheet with >500000 records,
created from an editor in csv format (comma separated
values).
I can view only 65536 records.
How can I increase the number of records?
M E Ramakrishnan
 
Hi
one Excel worksheet has a maximum of 65536 rows. There is no way around
this. You can try one of the following:
- split your csv file on different worksheets
- I'd recommend using a database for viewing this amount of data (e.g.
MS Access)
 
M E

You can't increase the number of Rows or Columns in Excel.

You would be better off using Access if you can't break up the incoming data
over multiple worksheets.

Gord Dibben Excel MVP
 
Back
Top