Pivot table more than 1 worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yang - 16 Oct 2006 12:18 GMT

I got a few text files and all of the text file is more than 65535. I need to
know how to create a Pivot table since all of the text file is inter-related
to each other.

Reply to this Message

smw226 - 16 Oct 2006 12:45 GMT

Hi Yang,

My prefered method would be to import all of the data to access then either
pivot in Access or use the access table as the data source for the pivot.

You can, however, use upto 4 different ranges to create a pivot table in
Excel and instead of using "Microsoft Office Excel List or database" select
"Multiple Consolidation Ranges"

Then, "I will Create the Page Fields"

Add all of your ranges, select "How many page fields do you want" and your
all done.

You will need to make sure that all of the headings are the same on the
spreadsheet.

Like I said though, Access would be my prefered option

HTH

Thanks,

Simon

>I got a few text files and all of the text file is more than 65535. I need to
>know how to create a Pivot table since all of the text file is inter-related
>to each other.

Signature

--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Reply to this Message

Yang - 17 Oct 2006 05:09 GMT

OK, I think I will stick to Access then... Thks a lot for Simon and Bill.

> Hi Yang,
>
[quoted text clipped - 24 lines]
> >know how to create a Pivot table since all of the text file is inter-related
> >to each other.

Reply to this Message

Bill Sharpe - 17 Oct 2006 04:25 GMT

> I got a few text files and all of the text file is more than 65535. I need to
> know how to create a Pivot table since all of the text file is inter-related
> to each other.

Excel 2007, due "soon", will solve the problem with 1,000,000 rows.
Quattro Pro will solve the problem now.
However, I agree that Access is the better solution.

Bill

Reply to this Message