Prev: Why does picking an cell highlight two cells?
Next: Duplicate data
From: mike_vr on 14 Apr 2010 12:40
Hi there

Just a quick one re: pivot tables. Say I have multiple worksheets all with
35k lines or so, all with the same headings and data formats, is it possible
to create a pivot table that looks at all four tabs and sums them into one
table on one worksheet?

Thanks

Mike
From: Dave Peterson on 14 Apr 2010 13:40
Debra Dalgleish shows how here:
http://contextures.com/xlPivot08.html

Me?

I've always copy|pasted to a new worksheet that held all the data.

mike_vr wrote:
>
> Hi there
>
> Just a quick one re: pivot tables. Say I have multiple worksheets all with
> 35k lines or so, all with the same headings and data formats, is it possible
> to create a pivot table that looks at all four tabs and sums them into one
> table on one worksheet?
>
> Thanks
>
> Mike

--

Dave Peterson
From: Roger Govier on 14 Apr 2010 18:28
Hi Mike

Unless you have XL2007, you won't be able to append sheets with 35K
lines, as 70K would be above the XL2003 limit of 65536 rows.

You could export the data as from each sheet as csv files.
Join all 4 sheets together with a DOS command, or Copy>Paste into
Wordpad to join them all together.
Then change the file extension to .txt.

Then in XL2003, you could use External Data source, and point at your
large txt file.
--
Regards
Roger Govier

mike_vr wrote:
> Hi there
>
> Just a quick one re: pivot tables. Say I have multiple worksheets all with
> 35k lines or so, all with the same headings and data formats, is it possible
> to create a pivot table that looks at all four tabs and sums them into one
> table on one worksheet?
>
> Thanks
>
> Mike
 | 
Pages: 1
Prev: Why does picking an cell highlight two cells?
Next: Duplicate data