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.

"Jesper" wrote:

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