Alternatives for Excel when too few rows

  • Thread starter Thread starter Jesper
  • Start date Start date
J

Jesper

Hi all

Monthly I get a datafile (comma seperated) from a customer and the data is
so vast that it will quickly (within a couple of months) reach more than the
65.000 rows that are possible in Excel.

Do anyone know an alternative solution, where I preferable could keep a
pivot functionality?

Access, maybe?

BR

Jesper
 
One thought: Excel 2007 will go to just over 1M rows. It has some issues
with graphing/charting still, and generally seems to perform slower than 2003
and earlier, but the data capacity is there. Not certain if there are any
issues with pivot tables - I don't use them much.

Access - yes, definitely the data capacity is there and you do have good
data analysis capabilities. With a little programming and setting up
tailored queries you could even export some (filtered) data to Excel for
further analysis.
 
Hi all

Monthly I get a datafile (comma seperated) from a customer and the data is
so vast that it will quickly (within a couple of months) reach more than the
65.000 rows that are possible in Excel.

Do anyone know an alternative solution, where I preferable could keep a
pivot functionality?

Access, maybe?

BR

Jesper
Click to expand...

Excel 2007 has 1,000,000 rows.
--ron
 
Hi all

Monthly I get a datafile (comma seperated) from a customer and the data is
so vast that it will quickly (within a couple of months) reach more than the
65.000 rows that are possible in Excel.

Do anyone know an alternative solution, where I preferable could keep a
pivot functionality?

Access, maybe?

BR

Jesper
Click to expand...

I wrote my own solution to the row limit but if you want a simple fix
upgrade. The latest Excel has a much higher limit.

Steve
 
I just started using 2007 but I only have 65k rows. I know others in my
office are using 2007 and have the 1 million rows. What the heck?
 
Are you opening your old .xls files?

Try saving them in xl2007's new file format, then reopen them.
 
Back
Top