pivot from more than 65K lines: how?

L

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
 
K

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

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

luis

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