software

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

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?''.quot;Joëlquot; wrote:

gt; Hello
gt; We try to use pivot table using external data from access to bypass 65K
gt; lines limitation . . . the pivot table blocks at 195.233 lines
gt; Is there an internal reason or does it depend from global size (cells) ?
gt; thanks for info
gt; 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

quot;Gary L Brownquot; wrote:

gt; Have you tired creating a Crosstab in Access and pulling that query from Excel?
gt; HTH,
gt; --
gt; Gary Brown
gt;
gt; If this post was helpful, please click the ''Yes'' button next to ''Was this
gt; Post Helpfull to you?''.
gt;
gt;
gt; quot;Joëlquot; wrote:
gt;
gt; gt; Hello
gt; gt; We try to use pivot table using external data from access to bypass 65K
gt; gt; lines limitation . . . the pivot table blocks at 195.233 lines
gt; gt; Is there an internal reason or does it depend from global size (cells) ?
gt; gt; thanks for info
gt; gt; Joël