ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2007 Pivot Table or OLAP Add-in (https://www.excelbanter.com/excel-discussion-misc-queries/124478-2007-pivot-table-olap-add.html)

OLAPUser

2007 Pivot Table or OLAP Add-in
 
In Excel 2007, I can't tell when I should be using Pivot Tables or the OLAP
Add-in. It seems that Pivot Tables have improved a lot, while the OLAP linked
to Analysis Services in SQL 2005 may have taken a step back. What is the main
difference between these Pivot Table and OLAP from a users perspective?

KoryS

2007 Pivot Table or OLAP Add-in
 
Excel 2007 PivotTables have replaced all of the functionality of the Excel
2003 Add-In for Analysis Services. If you've installed the add-in in the
past with 2003, you can ignore it for 2007.

-Kory

"OLAPUser" wrote:

In Excel 2007, I can't tell when I should be using Pivot Tables or the OLAP
Add-in. It seems that Pivot Tables have improved a lot, while the OLAP linked
to Analysis Services in SQL 2005 may have taken a step back. What is the main
difference between these Pivot Table and OLAP from a users perspective?



All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com