Pivot Tables over 65,536 rows

Gambler

anybody know how I can do this please?

I have about 76,000 rows of data I need to put into a pivot table but excel's limit is 65,536 rows.


Thanks

nickmack

Overcoming the pivot table limit in Excel

Gambler

thanks Nick, I've tried creating a table in Access but as I'm a novice I've worked out how to import half of the data from Excel but it won't let me import a 2nd worksheet and add it to the table.

crofty

Hi Gambler

Do you still need help with the problem? Maybe I could help?
I know access quite well , not tried doing pivot tables via excel via access database table as the source.
Maybe you could just send me the excel file and then will explain how I imported into access and then create the excel spreadsheet that will have pivot table.
mark