https://communities.sas.com/t5/Microsoft-Integration-with-SAS/AMO-and-OLAP-drill-though/m-p/73131#M988 Yes, the Add-In for Microsoft Office (starting with version 4.2) supports drill through to detail in PivotTables whose source is an OLAP cube. Excel 2007 also exposes this functionality, so the fact AMO exposes it is more important when using Excel versions prior to 2007. Fri, 02 Apr 2010 13:24:36 GMT CaseySmith 2010-04-02T13:24:36Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/AMO-and-OLAP-drill-though/m-p/73130#M987 The main question is:<BR /> Did Add-In for Microsoft Office support drill though to detail in pivot table using OLAP-cube as source?<BR /> In OLAP-cube this function (drill though) is enabled. Fri, 02 Apr 2010 09:06:58 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/AMO-and-OLAP-drill-though/m-p/73130#M987 n01known 2010-04-02T09:06:58Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/AMO-and-OLAP-drill-though/m-p/73131#M988 Yes, the Add-In for Microsoft Office (starting with version 4.2) supports drill through to detail in PivotTables whose source is an OLAP cube. Excel 2007 also exposes this functionality, so the fact AMO exposes it is more important when using Excel versions prior to 2007. Fri, 02 Apr 2010 13:24:36 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/AMO-and-OLAP-drill-though/m-p/73131#M988 CaseySmith 2010-04-02T13:24:36Z