| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2000 Pivot table using offline OLAP CUB as the data source
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel 2000 Pivot table using offline OLAP CUB as the data source
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. "Samson Tang" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OLAP Pivot Table - HT Find source data | Excel Discussion (Misc queries) | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Pivot Table Row Field Format (OLAP Source) | Excel Discussion (Misc queries) | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| Creating an offline OLAP cube | Excel Discussion (Misc queries) | |||
Hybrid Mode
