excel row limitations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using excel (2000) pivot table for data analysis and the data has
outgrown the number of rows (66,536). We've looked at using excel XP, but
ran into the same row restriction. While I understand this is not the proper
tool for this amount of data, I need an excel solution for the remainder of
2004. Is there a way to add more rows to excel? Or is there a way to have
two data worksheets in excel.
As information, I add data on a monthly basis and share the six other users.
 
Hi
no chance to add more rows. One way:
put your data in a databse (Access for example)
- use Excel's pivot table on this database
 
Back
Top