Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table against an Access Database
Using OS 2000 with MS Excel 2000 and Access 2000.
I used an external data source and created an OLAP cube against an Access database of about 285,000 records. It all works fine except I can't show detail. I can't drill down to the lowest level. Is there a way of doing this in Excel? Thanks. |
#2
|
|||
|
|||
Hi Richard
Excel only allows for 65536 rows, if drilling down exceeds this limit then it won't work ... Cheers JulieD "Richard" wrote in message ... Using OS 2000 with MS Excel 2000 and Access 2000. I used an external data source and created an OLAP cube against an Access database of about 285,000 records. It all works fine except I can't show detail. I can't drill down to the lowest level. Is there a way of doing this in Excel? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |