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 <(E-Mail Removed)>
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

On Wed, 2 Apr 2008 04:38:01 -0700, Jesper
<(E-Mail Removed)> 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

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

--
Neural Planner Software Ltd http://npsl1.com
EasyNN-plus. Build Neural Networks. http://www.easynn.com
SwingNN. Forecast the Future. http://www.swingnn.com

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 <(E-Mail Removed)>
> 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 <(E-Mail Removed)>
> > 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 <(E-Mail Removed)>
> > > 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
>