View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Alternatives for Excel when too few rows

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