Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
How do I remove the (blank) from an excel pivot table? | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |