Pivot Table against an Access Database

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

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.
 
Hi Richard

Excel only allows for 65536 rows, if drilling down exceeds this limit then
it won't work ...

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLAP Pivot Table 1
Undo "Convert to formulas" pivot function 1
Automatic refresh of pivot tables 2
Filter list not correctly refreshed 3
Pivot table layout that popluates the row label in each row? 3
Trouble using Access as source for Pivot Table 0
OLAP Pivot Table - HT Find source data 1
create a calculated field for pivot tables 2

Back
Top