Have you tired creating a Crosstab in Access and pulling that query from Excel?
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Joël" wrote:

Hello
We try to use pivot table using external data from access to bypass 65K
lines limitation . . . the pivot table blocks at 195.233 lines
Is there an internal reason or does it depend from global size (cells) ?
thanks for info
Joël