pivot from more than 65K lines: how?

  • Thread starter Thread starter luis
  • Start date Start date
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
 
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.
 
If you have Microsoft Access, you could store the data in a table there.
Then, create the pivot table from the Access table.
 
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...
 
Back
Top