pivot from more than 65K lines: how?

[luis]

What I am trying to do: have several excel files with data and want to
consolidate in a single file

What I did: tried to paste all the data in a single file and create a pivot
from there... the problem is that I can not copy after reaching 65K
lines....

Trying to create a pivot from *multiple* excel does not give me the
possibility to put in the layout the fields I want (as if I was using a
single sheet)... as it consolidates all the fields in the different
tables...

Any urgent help please?..

MANY TIA!
luis

 

[Ken Wright]

Do you have Access? If so then import all your excel sheets into a single table
and then use that as the source for an 'Import Data' operation from the Data
menu.

 

[Debra Dalgleish]

If you have Microsoft Access, you could store the data in a table there.
Then, create the pivot table from the Access table.

 

[luis]

What I am trying to do: have several excel files with data and want to
consolidate in a single file

What I did: tried to paste all the data in a single file and create a
pivot from there... the problem is that I can not copy after reaching 65K
lines....

Trying to create a pivot from *multiple* excel does not give me the
possibility to put in the layout the fields I want (as if I was using a
single sheet)... as it consolidates all the fields in the different
tables...

Any urgent help please?..

MANY TIA!
luis