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

G

Guest

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.
 
G

Guest

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

Excel 2003 SP3 - can't find the .cub files 2
Local cub file in 2000/XP 2
OLAP Creation in Excel / MS Query -- .cub files 1
Access #Error & Excel Pivot 0
Excel 2000 Pivot table in Excel 2007 5
Pivot using 250,000 rows of data in Excel? 1
Changing Data Source on Multiple Pivot Tables at once 1
Excel file with olap cube gets corrupted 1

Top