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.

"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

On Wed, 2 Apr 2008 04:38:01 -0700, 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

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

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?

"Ron Rosenfeld" wrote:

On Wed, 2 Apr 2008 04:38:01 -0700, 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

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

Are you opening your old .xls files?

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


07 Excel Newbie wrote:

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?

"Ron Rosenfeld" wrote:

On Wed, 2 Apr 2008 04:38:01 -0700, 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

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


--

Dave Peterson

Thanks it worked.

"Dave Peterson" wrote:

Are you opening your old .xls files?

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


07 Excel Newbie wrote:

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?

"Ron Rosenfeld" wrote:

On Wed, 2 Apr 2008 04:38:01 -0700, 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

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


--

Dave Peterson