Pivot table more than 1 worksheet

[Guest]

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.

 

[smw226 via OfficeKB.com]

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.

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

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

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-new/200610/1

 

[Bill Sharpe]

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

 

[Guest]

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

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.

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

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

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-new/200610/1