Excel pivot table limitation when having Access

[Joël]

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

 

[Gary L Brown]

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

 

[Joël]

Thanks for your answer but unfortunately end-users don't have acces to
Access; only to Excel . . . so the need to offer the pivot table via Excel