Excel 2000 Pivot table using offline OLAP CUB as the data source

S

Samson Tang

Hello professtionals,

I need to use Pivot table using offline OLAP CUB as the data source to
analys a large amount of data. I would like to know:
What is the maximum size for a CUB file in Excel 2000?
What is the maximum size of data that Excel 2000 pivot table support?

Thank you very much.
 
T

toni.gee

Not sure what the maximum size is for an external data source, or even if
it's restricted. Maximum size for a pivot based on a worksheet is 65,536
records (maxm. worksheet length). I regularly use pivots reading from Access
databases of 2-300,000 records without a problem.
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Excel 2003 SP3 - can't find the .cub files 2
Excel does not accept text format! 0
several Offline-OLAP pivot tables on different sheets 0
Consolidation Table from Different Excel Tabs with Different Format 1
Excel 2007 pivot table using analysis services cube as data source 0
Trying To Save An Offline .cub File... 0
OLAP Creation in Excel / MS Query -- .cub files 0

Top