Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Adding a Little Animation to Your Life
Converting a Range of URLs to Hyperlinks
Making the Formula Bar Persistent
John notes that in Excel versions prior to Excel 2007 it was possible to create an OLAP cube file using Microsoft Query. This feature does not appear to be supported in Excel 2007, and John wonders why it isn't included.
The official word on this matter seems to be available at a blog maintained by the MSDN team at Microsoft:
http://blogs.msdn.com/excel/archive/2006/08/24/718786.aspx
The OLAP cube functionality is listed, along with a list of other features no longer supported in Excel 2007. It seems that the primary reason for it being dropped was that it wasn't used that much by folks.
Interestingly, OLAP cubes created in previous versions of Excel are still supported in Excel 2007, so it is possible that you can use the earlier version to do the cube creation and then do the rest of your work in Excel 2007. (This presumes that you still have access to a system with an older version of Excel installed.)
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6792) applies to Microsoft Excel versions: 2007
A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best.