Pivot table more than 1 worksheet

Y

Yang

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.
 
B

Bill Sharpe

Yang said:
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.
Click to expand...
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
 
Y

Yang

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

smw226 via OfficeKB.com said:
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.
Click to expand...

--
--------------------
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
Click to expand...
 
Top