Excel pivot table limitation when having Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top