Hi!
I'm stuck with too many rows (250 000 and counting) of data that I need to manipulate in a Pivot table. If I could use my Excel 2007 this would be no problem at all but I have to make it work in Excel 2003.
I tried to handle the problem with consolidated Pivot Table but I wasn't too happy with the results. Too few options and a lot of work to get rid of the "unnecessary" columns of data. I also tried combining 5 "normal" Pivot Tables with a macro to combine the data into one single "normal" table but if anybody needs to change the row/column fields in any way, the whole combination thing is going to fall apart.
Now I'm thinking if Access could be used as a help but the problem is I have no experience whatsoever about Access and the deadline is on Wednesday. And the whole thing should be done with macros so that it'll be as easy as possible for the users to add more rows data to the pivot tables.
I've understood that Pivot Tables are not limitted to any number of rows they can handle but the only limitation is the computer memory available.
What I'm after is a simple way to combine 5-6 full worksheets of data into a one "normal" Pivot Table. All the worksheets will have all the same columns (30 of them in each worksheet) and up to 55 000 rows of data on each worksheet.
Could anybody help me out by coming up with a way to solve this problem?
I'm stuck with too many rows (250 000 and counting) of data that I need to manipulate in a Pivot table. If I could use my Excel 2007 this would be no problem at all but I have to make it work in Excel 2003.
I tried to handle the problem with consolidated Pivot Table but I wasn't too happy with the results. Too few options and a lot of work to get rid of the "unnecessary" columns of data. I also tried combining 5 "normal" Pivot Tables with a macro to combine the data into one single "normal" table but if anybody needs to change the row/column fields in any way, the whole combination thing is going to fall apart.
Now I'm thinking if Access could be used as a help but the problem is I have no experience whatsoever about Access and the deadline is on Wednesday. And the whole thing should be done with macros so that it'll be as easy as possible for the users to add more rows data to the pivot tables.
I've understood that Pivot Tables are not limitted to any number of rows they can handle but the only limitation is the computer memory available.
What I'm after is a simple way to combine 5-6 full worksheets of data into a one "normal" Pivot Table. All the worksheets will have all the same columns (30 of them in each worksheet) and up to 55 000 rows of data on each worksheet.
Could anybody help me out by coming up with a way to solve this problem?