I have a 60mb Excel file containing around 2.1 million rows of information split across monthly worksheets (i.e. October contains 150,000 etc).
I can't amalgamate these in to a single worksheet because of Excel's maximum number of rows.
The PivotTable I'm trying to produce is something along these lines - this is taken from a single worksheet.
I want to be able to see how many times my students, parents or staff have accessed certain pages - hence the setup of...
- Values: Count of date
- Row Labels: filename
- Report Filter: profile
If I use the Wizard, I can consolidate all of the worksheets' data into a single PT, but the labels don't seem to work the way I want them to.
Is there any way of EITHER adding additional ranges to the manual PT (possibly using 3D references? I'm not sure how they work - currently the reference I'm using for an individual worksheet is
'September 11'!$A$1:$K$137145), OR setting up the PT Wizard so that my fields become usable in the way I want them?
Thanks in advance,