 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Excel 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. 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. > Hello professtionals, > [quoted text clipped - 4 lines] > > Thank you very much.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.