Excel pivot table limitation when having Access
 

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

Excel pivot table limitation when having Access
 

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

Excel pivot table limitation when having Access
 

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

"Gary L Brown" wrote:

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