Use Msdn to search the Web.http://feedproxy.google.com/~r/microsoft/SKdu/~3/MS1hdkr4xFQ/default.aspx<p><a href="http://feedads.g.doubleclick.net/~a/_T4Yjvt5TM-iopow1oexSueotXY/0/da"><img src="http://feedads.g.doubleclick.net/~a/_T4Yjvt5TM-iopow1oexSueotXY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/_T4Yjvt5TM-iopow1oexSueotXY/1/da"><img src="http://feedads.g.doubleclick.net/~a/_T4Yjvt5TM-iopow1oexSueotXY/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/MS1hdkr4xFQ" height="1" width="1"/>http://blogs.msdn.com/excel/archive/tags/PivotTables/default.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/wdQmXFh4t4E/pivottables-calculated-items.aspxToday's author: David Gainer, a Program Manager on the Excel team. PivotTables are designed to help users make sense of large amounts of data by providing an easy way to build a ... <p><a href="http://feedads.g.doubleclick.net/~a/s4AfRlQ4NaslXoIOwy3zDAepebQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/s4AfRlQ4NaslXoIOwy3zDAepebQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/s4AfRlQ4NaslXoIOwy3zDAepebQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/s4AfRlQ4NaslXoIOwy3zDAepebQ/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/wdQmXFh4t4E" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2008/05/08/pivottables-calculated-items.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/lgF0Z1p3_10/dd891207.aspxSummary: Learn how to programmatically add a PivotTable to an Excel 2007 worksheet. (9 printed pages) <p><a href="http://feedads.g.doubleclick.net/~a/H0rJIyiNqM3nlVG7zDiw868QZNg/0/da"><img src="http://feedads.g.doubleclick.net/~a/H0rJIyiNqM3nlVG7zDiw868QZNg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/H0rJIyiNqM3nlVG7zDiw868QZNg/1/da"><img src="http://feedads.g.doubleclick.net/~a/H0rJIyiNqM3nlVG7zDiw868QZNg/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/lgF0Z1p3_10" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/dd891207.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/iMSGjybk4gw/common-questions-around-excel-2007-OLAP-PivotTables.aspxToday's author: Allan Folting, a program manager who works on the Excel team. I have gotten lots of questions from customers around specific functionality in Microsoft Excel 2007 ... <p><a href="http://feedads.g.doubleclick.net/~a/wx3A7d-cJ2DlYz6ytDMqZqeyeNY/0/da"><img src="http://feedads.g.doubleclick.net/~a/wx3A7d-cJ2DlYz6ytDMqZqeyeNY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/wx3A7d-cJ2DlYz6ytDMqZqeyeNY/1/da"><img src="http://feedads.g.doubleclick.net/~a/wx3A7d-cJ2DlYz6ytDMqZqeyeNY/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/iMSGjybk4gw" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2008/02/05/common-questions-around-excel-2007-OLAP-PivotTables.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/LEAL_vV80kU/509918.aspxIn this post I’ll walk you through three Analysis Services features that we now support in Excel PivotTables – server formatting, translations, and member properties. One thing ... <p><a href="http://feedads.g.doubleclick.net/~a/FkMrkqHTUmyQArMhrO-ObSpl218/0/da"><img src="http://feedads.g.doubleclick.net/~a/FkMrkqHTUmyQArMhrO-ObSpl218/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/FkMrkqHTUmyQArMhrO-ObSpl218/1/da"><img src="http://feedads.g.doubleclick.net/~a/FkMrkqHTUmyQArMhrO-ObSpl218/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/LEAL_vV80kU" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2006/01/05/509918.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/IApLaln2ID0/microsoft.office.tools.excel.worksheet.pivottables(VS.80).aspxGets an object that represents either a single PivotTable report (a Microsoft.Office.Interop.Excel.PivotTable object) or a collection of all the PivotTable reports (a Microsoft ... <p><a href="http://feedads.g.doubleclick.net/~a/lcesYWGsHP78WxM0ykFQGPiN-AE/0/da"><img src="http://feedads.g.doubleclick.net/~a/lcesYWGsHP78WxM0ykFQGPiN-AE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/lcesYWGsHP78WxM0ykFQGPiN-AE/1/da"><img src="http://feedads.g.doubleclick.net/~a/lcesYWGsHP78WxM0ykFQGPiN-AE/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/IApLaln2ID0" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.pivottables(VS.80).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/dBspUWritqU/bb178263.aspxA collection of all the PivotTable objects on the specified worksheet. Remarks. Because PivotTable report programming can be complex, it’s generally easiest to record PivotTable ... <p><a href="http://feedads.g.doubleclick.net/~a/Q9r3q3TmR2WxJHMqQKxsbX53Vb0/0/da"><img src="http://feedads.g.doubleclick.net/~a/Q9r3q3TmR2WxJHMqQKxsbX53Vb0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/Q9r3q3TmR2WxJHMqQKxsbX53Vb0/1/da"><img src="http://feedads.g.doubleclick.net/~a/Q9r3q3TmR2WxJHMqQKxsbX53Vb0/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/dBspUWritqU" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb178263.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/yqTNx0w2evU/help-us-make-excel-pivottables-faster.aspxA long time ago, I posted a request for calculation-intensive workbooks and received a lot of very valuable Excel workbooks in response – again, to those that helped out; it ... <p><a href="http://feedads.g.doubleclick.net/~a/LRUQ0ln04Ll7w6smv8zo9iMlcHs/0/da"><img src="http://feedads.g.doubleclick.net/~a/LRUQ0ln04Ll7w6smv8zo9iMlcHs/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/LRUQ0ln04Ll7w6smv8zo9iMlcHs/1/da"><img src="http://feedads.g.doubleclick.net/~a/LRUQ0ln04Ll7w6smv8zo9iMlcHs/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/yqTNx0w2evU" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2007/04/23/help-us-make-excel-pivottables-faster.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/mRDRpYx0_F4/aa174281(office.11).aspxA collection of all the PivotTable objects on the specified worksheet. Using the PivotTables Collection. Use the PivotTables method to return the PivotTables collection. <p><a href="http://feedads.g.doubleclick.net/~a/5wvOtU-MzATWoPydgTFm986Q9KM/0/da"><img src="http://feedads.g.doubleclick.net/~a/5wvOtU-MzATWoPydgTFm986Q9KM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/5wvOtU-MzATWoPydgTFm986Q9KM/1/da"><img src="http://feedads.g.doubleclick.net/~a/5wvOtU-MzATWoPydgTFm986Q9KM/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/mRDRpYx0_F4" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa174281(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/Wbezd-DfR1E/211517Discusses some of the limitations of PivotTables in Excel 2000. You can use page fields or server page fields in PivotTables to avoid running in to these limits. <p><a href="http://feedads.g.doubleclick.net/~a/Y13va4OiWiLPVq7JiGaf3YPV5EQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/Y13va4OiWiLPVq7JiGaf3YPV5EQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/Y13va4OiWiLPVq7JiGaf3YPV5EQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/Y13va4OiWiLPVq7JiGaf3YPV5EQ/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/Wbezd-DfR1E" height="1" width="1"/>http://support.microsoft.com/kb/211517http://feedproxy.google.com/~r/microsoft/SKdu/~3/OpALrAJ7xpE/234700Microsoft Excel allows you to create PivotTable reports based on Online Analytical Processing (OLAP) source data. If you work with PivotTable reports that are based on OLAP source ... <p><a href="http://feedads.g.doubleclick.net/~a/WbZH8KrI5Un3D_HrZMDEAjQu0DQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/WbZH8KrI5Un3D_HrZMDEAjQu0DQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/WbZH8KrI5Un3D_HrZMDEAjQu0DQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/WbZH8KrI5Un3D_HrZMDEAjQu0DQ/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/OpALrAJ7xpE" height="1" width="1"/>http://support.microsoft.com/kb/234700http://feedproxy.google.com/~r/microsoft/SKdu/~3/dpzFW-8xQS8/using-pivottables-to-analyze-data-from-a-sharepoint-list.aspxToday's author, Diego Oppenheimer, a Program Manager on the Excel team, talks about connecting PivotTables to data stored in SharePoint Lists. Many of us on the Excel team have ... <p><a href="http://feedads.g.doubleclick.net/~a/YwYGvIec1p62hewvCJSDva1B4Kk/0/da"><img src="http://feedads.g.doubleclick.net/~a/YwYGvIec1p62hewvCJSDva1B4Kk/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/YwYGvIec1p62hewvCJSDva1B4Kk/1/da"><img src="http://feedads.g.doubleclick.net/~a/YwYGvIec1p62hewvCJSDva1B4Kk/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/dpzFW-8xQS8" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2008/11/06/using-pivottables-to-analyze-data-from-a-sharepoint-list.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/8K5llHmI6OA/506815.aspxIn this article, I’ll cover a small yet very useful PivotTable feature – deferring PivotTable updates. In current versions of Excel, PivotTables are updated each time a field ... <p><a href="http://feedads.g.doubleclick.net/~a/9RQ5aRTAKB6emoFZyodr2p-1Hi0/0/da"><img src="http://feedads.g.doubleclick.net/~a/9RQ5aRTAKB6emoFZyodr2p-1Hi0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/9RQ5aRTAKB6emoFZyodr2p-1Hi0/1/da"><img src="http://feedads.g.doubleclick.net/~a/9RQ5aRTAKB6emoFZyodr2p-1Hi0/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/8K5llHmI6OA" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2005/12/22/506815.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/-5pMQ8l1J9c/microsoft.office.interop.excel.pivottables_members(office.11).aspxA collection of all the PivotTable objects on the specified worksheet. <p><a href="http://feedads.g.doubleclick.net/~a/zP0WfLEbdZTRrAGrGZFO_Mtlm-U/0/da"><img src="http://feedads.g.doubleclick.net/~a/zP0WfLEbdZTRrAGrGZFO_Mtlm-U/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/zP0WfLEbdZTRrAGrGZFO_Mtlm-U/1/da"><img src="http://feedads.g.doubleclick.net/~a/zP0WfLEbdZTRrAGrGZFO_Mtlm-U/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/-5pMQ8l1J9c" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables_members(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/qfpnst5nEdI/analyzing-data-functions-of-pivottables.aspxToday’s author, Monica Poinescu, a Software Developer in Test on the Excel team, discusses two different approaches to analyzing data in Excel. Edit: I've attached a file at the ... <p><a href="http://feedads.g.doubleclick.net/~a/IRY-SIS8dE7F14yOj3VgDebiUNY/0/da"><img src="http://feedads.g.doubleclick.net/~a/IRY-SIS8dE7F14yOj3VgDebiUNY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/IRY-SIS8dE7F14yOj3VgDebiUNY/1/da"><img src="http://feedads.g.doubleclick.net/~a/IRY-SIS8dE7F14yOj3VgDebiUNY/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/qfpnst5nEdI" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2009/03/23/analyzing-data-functions-of-pivottables.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/iWwe9pKDrnk/using-cell-text-to-filter-pivottables.aspxSometimes it would be useful to be able to use cells to select items in a PivotTable. For example, let's say we have a PivotTable containing a field called Region. Instead of using ... <p><a href="http://feedads.g.doubleclick.net/~a/N6ib-mVeeu4oYsjAu-DFHaGXK60/0/da"><img src="http://feedads.g.doubleclick.net/~a/N6ib-mVeeu4oYsjAu-DFHaGXK60/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/N6ib-mVeeu4oYsjAu-DFHaGXK60/1/da"><img src="http://feedads.g.doubleclick.net/~a/N6ib-mVeeu4oYsjAu-DFHaGXK60/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/iWwe9pKDrnk" height="1" width="1"/>http://blogs.msdn.com/gabhan_berry/archive/2008/01/31/using-cell-text-to-filter-pivottables.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/EFaZGKSdWwY/microsoft.office.interop.excel.pivottables.add(office.11).aspxAdds a new PivotTable report. Returns a PivotTable object. ... Adds a new PivotTable report. Returns a PivotTable object. Namespace: Microsoft.Office.Interop.Excel <p><a href="http://feedads.g.doubleclick.net/~a/vdx1ulTe1gwMrVEy8JNGjDABYLg/0/da"><img src="http://feedads.g.doubleclick.net/~a/vdx1ulTe1gwMrVEy8JNGjDABYLg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/vdx1ulTe1gwMrVEy8JNGjDABYLg/1/da"><img src="http://feedads.g.doubleclick.net/~a/vdx1ulTe1gwMrVEy8JNGjDABYLg/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/EFaZGKSdWwY" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables.add(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/qVbnVc8id-I/211515This article describes how to use server page fields to reduce the amount of data returned from an external data source to a PivotTable. This is useful when creating PivotTables ... <p><a href="http://feedads.g.doubleclick.net/~a/C7Oe0MwB-1cqY5ppEQ9m9KRMuuo/0/da"><img src="http://feedads.g.doubleclick.net/~a/C7Oe0MwB-1cqY5ppEQ9m9KRMuuo/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/C7Oe0MwB-1cqY5ppEQ9m9KRMuuo/1/da"><img src="http://feedads.g.doubleclick.net/~a/C7Oe0MwB-1cqY5ppEQ9m9KRMuuo/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/qVbnVc8id-I" height="1" width="1"/>http://support.microsoft.com/kb/211515http://feedproxy.google.com/~r/microsoft/SKdu/~3/Ioz_UrY3CLY/503854.aspxAs I mentioned a few posts back, one of the key goals for PivotTables in Excel 12 was to use the Ribbon and new dialogs to expose PivotTables’ capabilities to a much broader ... <p><a href="http://feedads.g.doubleclick.net/~a/WVtZnkrCvNGifGICHE9HZXQ7WYo/0/da"><img src="http://feedads.g.doubleclick.net/~a/WVtZnkrCvNGifGICHE9HZXQ7WYo/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/WVtZnkrCvNGifGICHE9HZXQ7WYo/1/da"><img src="http://feedads.g.doubleclick.net/~a/WVtZnkrCvNGifGICHE9HZXQ7WYo/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/Ioz_UrY3CLY" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2005/12/14/503854.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/iMuypVz-rbQ/new-whitepaper-designing-sql-server-2005-analysis-services-cubes-for-excel-2007-pivottables.aspxNew Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables . Another Excel 2007 whitepaper is available. According to the overview, "Microsoft ... <p><a href="http://feedads.g.doubleclick.net/~a/VPX2M83CcQ44-yRBm2hy14-UEns/0/da"><img src="http://feedads.g.doubleclick.net/~a/VPX2M83CcQ44-yRBm2hy14-UEns/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/VPX2M83CcQ44-yRBm2hy14-UEns/1/da"><img src="http://feedads.g.doubleclick.net/~a/VPX2M83CcQ44-yRBm2hy14-UEns/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/iMuypVz-rbQ" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2007/04/10/new-whitepaper-designing-sql-server-2005-analysis-services-cubes-for-excel-2007-pivottables.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/7hkMc0bV6ws/creating-custom-calculated-members-and-sets-in-olap-pivottables.aspxIf you are using PivotTables against an OLAP data source you may find it useful to be able to create your own custom, calculated measures and sets. These calculations are client ... <p><a href="http://feedads.g.doubleclick.net/~a/PwX5mJAeo1lM_nKZDcCc5dEvtRo/0/da"><img src="http://feedads.g.doubleclick.net/~a/PwX5mJAeo1lM_nKZDcCc5dEvtRo/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/PwX5mJAeo1lM_nKZDcCc5dEvtRo/1/da"><img src="http://feedads.g.doubleclick.net/~a/PwX5mJAeo1lM_nKZDcCc5dEvtRo/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/7hkMc0bV6ws" height="1" width="1"/>http://blogs.msdn.com/gabhan_berry/archive/2008/02/06/creating-custom-calculated-members-and-sets-in-olap-pivottables.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/v2HpbFkyXEU/microsoft.office.interop.excel.pivottables(office.11).aspxA collection of all the PivotTable objects on the specified worksheet. <p><a href="http://feedads.g.doubleclick.net/~a/g_0TOA7Ah3ssZznme8VyuIRUcQw/0/da"><img src="http://feedads.g.doubleclick.net/~a/g_0TOA7Ah3ssZznme8VyuIRUcQw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/g_0TOA7Ah3ssZznme8VyuIRUcQw/1/da"><img src="http://feedads.g.doubleclick.net/~a/g_0TOA7Ah3ssZznme8VyuIRUcQw/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/v2HpbFkyXEU" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/nZKo--xmBwo/microsoft.office.tools.excel.worksheet.pivottables.aspxGets an object that represents either a single PivotTable report (a PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet. <p><a href="http://feedads.g.doubleclick.net/~a/8NcIYI3UKxrQLHMrf-gJY4c8RCI/0/da"><img src="http://feedads.g.doubleclick.net/~a/8NcIYI3UKxrQLHMrf-gJY4c8RCI/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/8NcIYI3UKxrQLHMrf-gJY4c8RCI/1/da"><img src="http://feedads.g.doubleclick.net/~a/8NcIYI3UKxrQLHMrf-gJY4c8RCI/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/nZKo--xmBwo" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.pivottables.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/Pvr4fQxfxKE/cc679025.aspxYou can use Microsoft Office Excel to display information related to analysis services that is stored in the Team Foundation Server Data Warehouse. The analysis services database ... <p><a href="http://feedads.g.doubleclick.net/~a/MmmW6Ne_Mmrl1VuIbRMeTQFZq5Q/0/da"><img src="http://feedads.g.doubleclick.net/~a/MmmW6Ne_Mmrl1VuIbRMeTQFZq5Q/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/MmmW6Ne_Mmrl1VuIbRMeTQFZq5Q/1/da"><img src="http://feedads.g.doubleclick.net/~a/MmmW6Ne_Mmrl1VuIbRMeTQFZq5Q/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/Pvr4fQxfxKE" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/cc679025.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/zP5BJDNtA5M/142589In Microsoft Excel, you can create a PivotTable from multiple consolidation ranges. These ranges can be on the same worksheet, on separate worksheets, or even in separate workbooks <p><a href="http://feedads.g.doubleclick.net/~a/YTwrOwI7KrNalmkFuBxiPLLaUng/0/da"><img src="http://feedads.g.doubleclick.net/~a/YTwrOwI7KrNalmkFuBxiPLLaUng/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/YTwrOwI7KrNalmkFuBxiPLLaUng/1/da"><img src="http://feedads.g.doubleclick.net/~a/YTwrOwI7KrNalmkFuBxiPLLaUng/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/zP5BJDNtA5M" height="1" width="1"/>http://support.microsoft.com/kb/142589http://feedproxy.google.com/~r/microsoft/SKdu/~3/UWzkLwzqfpA/213947In Excel 2000, you can create a PivotTable from multiple consolidation ranges. These ranges can be on the same worksheet, on separate worksheets, or even in separate workbooks. <p><a href="http://feedads.g.doubleclick.net/~a/l5y4EukctdzXngzqwIzrfjFtkfE/0/da"><img src="http://feedads.g.doubleclick.net/~a/l5y4EukctdzXngzqwIzrfjFtkfE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/l5y4EukctdzXngzqwIzrfjFtkfE/1/da"><img src="http://feedads.g.doubleclick.net/~a/l5y4EukctdzXngzqwIzrfjFtkfE/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/UWzkLwzqfpA" height="1" width="1"/>http://support.microsoft.com/kb/213947http://feedproxy.google.com/~r/microsoft/SKdu/~3/2rGrOjFXP4U/microsoft.office.tools.excel.worksheet.pivottables(VS.89).aspxGets an object that represents either a single PivotTable report (a PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet. <p><a href="http://feedads.g.doubleclick.net/~a/4TJD4wNrLJyZa55tkWacR6w-YD0/0/da"><img src="http://feedads.g.doubleclick.net/~a/4TJD4wNrLJyZa55tkWacR6w-YD0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/4TJD4wNrLJyZa55tkWacR6w-YD0/1/da"><img src="http://feedads.g.doubleclick.net/~a/4TJD4wNrLJyZa55tkWacR6w-YD0/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/2rGrOjFXP4U" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.pivottables(VS.89).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/JkNpWtCzsp8/730796.aspxIn Excel 2007, we have invested a lot of our time improving PivotTables. If you are just joining, you can find a number of blog posts describing that work here. <p><a href="http://feedads.g.doubleclick.net/~a/xfRwjI8L8T9IZnZZH3C4fy26BVA/0/da"><img src="http://feedads.g.doubleclick.net/~a/xfRwjI8L8T9IZnZZH3C4fy26BVA/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/xfRwjI8L8T9IZnZZH3C4fy26BVA/1/da"><img src="http://feedads.g.doubleclick.net/~a/xfRwjI8L8T9IZnZZH3C4fy26BVA/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/JkNpWtCzsp8" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2006/08/30/730796.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/nVEvSKl0_po/bb407625.aspxExcel has special handling of attribute hierarchies in OLAP PivotTables, so attribute hierarchies are marked as such. MDSCHEMA_HIERARCHIES: HIERARCHY_DISPLAY_FOLDER <p><a href="http://feedads.g.doubleclick.net/~a/7QTK3ESO4-6uo3fGMawSfYiyUnQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/7QTK3ESO4-6uo3fGMawSfYiyUnQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/7QTK3ESO4-6uo3fGMawSfYiyUnQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/7QTK3ESO4-6uo3fGMawSfYiyUnQ/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/nVEvSKl0_po" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb407625.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/3Yz1m4rdKsk/aa174280(office.11).aspxRepresents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a ... <p><a href="http://feedads.g.doubleclick.net/~a/2RKhnqMxvBuSAyU5NV5hesL7M1U/0/da"><img src="http://feedads.g.doubleclick.net/~a/2RKhnqMxvBuSAyU5NV5hesL7M1U/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/2RKhnqMxvBuSAyU5NV5hesL7M1U/1/da"><img src="http://feedads.g.doubleclick.net/~a/2RKhnqMxvBuSAyU5NV5hesL7M1U/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/3Yz1m4rdKsk" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa174280(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/dG3KlmdQ3Tw/179331This article discusses some of the limitations of the PivotTable feature in Microsoft Excel. <p><a href="http://feedads.g.doubleclick.net/~a/UBgjBqtNS_zq_Qo5CTUmAmZiH54/0/da"><img src="http://feedads.g.doubleclick.net/~a/UBgjBqtNS_zq_Qo5CTUmAmZiH54/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/UBgjBqtNS_zq_Qo5CTUmAmZiH54/1/da"><img src="http://feedads.g.doubleclick.net/~a/UBgjBqtNS_zq_Qo5CTUmAmZiH54/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/dG3KlmdQ3Tw" height="1" width="1"/>http://support.microsoft.com/kb/179331http://feedproxy.google.com/~r/microsoft/SKdu/~3/v6JrUhDK-mQ/microsoft.office.interop.excel.pivottables.application(office.11).aspxReturns an Application object that represents the Microsoft Excel application. Read-only. <p><a href="http://feedads.g.doubleclick.net/~a/akMoI0FpadsezKsUImQxGINYXy0/0/da"><img src="http://feedads.g.doubleclick.net/~a/akMoI0FpadsezKsUImQxGINYXy0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/akMoI0FpadsezKsUImQxGINYXy0/1/da"><img src="http://feedads.g.doubleclick.net/~a/akMoI0FpadsezKsUImQxGINYXy0/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/v6JrUhDK-mQ" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables.application(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/Wvy9YxcTtUo/186137.aspxThe aim for the Excel Add-in for Analysis Services is to provide a fuller reporting solution for OLAP cubes than is natively enabled in Excel PivotTables. <p><a href="http://feedads.g.doubleclick.net/~a/9EMXAr0RAN_Dfxy5oNfUvE8Af2k/0/da"><img src="http://feedads.g.doubleclick.net/~a/9EMXAr0RAN_Dfxy5oNfUvE8Af2k/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/9EMXAr0RAN_Dfxy5oNfUvE8Af2k/1/da"><img src="http://feedads.g.doubleclick.net/~a/9EMXAr0RAN_Dfxy5oNfUvE8Af2k/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/Wvy9YxcTtUo" height="1" width="1"/>http://blogs.msdn.com/tims/archive/2004/07/17/186137.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/GkB8Eig7qyI/microsoft.office.interop.excel.pivottables.creator(office.11).aspxReturns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which ... <p><a href="http://feedads.g.doubleclick.net/~a/fCnjQ7jVrebo2fst_cRoUuMRc7g/0/da"><img src="http://feedads.g.doubleclick.net/~a/fCnjQ7jVrebo2fst_cRoUuMRc7g/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/fCnjQ7jVrebo2fst_cRoUuMRc7g/1/da"><img src="http://feedads.g.doubleclick.net/~a/fCnjQ7jVrebo2fst_cRoUuMRc7g/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/GkB8Eig7qyI" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables.creator(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/QGLUzIxDkso/microsoft.office.interop.excel.pivottables_properties(office.11).aspxName Description Application: Returns an Application object that represents the Microsoft Excel application. Read-only. <p><a href="http://feedads.g.doubleclick.net/~a/8vrTmr-knZlmM06T8iV18TtcieI/0/da"><img src="http://feedads.g.doubleclick.net/~a/8vrTmr-knZlmM06T8iV18TtcieI/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/8vrTmr-knZlmM06T8iV18TtcieI/1/da"><img src="http://feedads.g.doubleclick.net/~a/8vrTmr-knZlmM06T8iV18TtcieI/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/QGLUzIxDkso" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables_properties(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/ulQjDsbYAUQ/excel-2010-new-search-filter.aspxExploring large data sets and creating filters has never been easier than with Excel 2010. Tables, PivotTables and PivotCharts now have a new search functionality that easily ... <p><a href="http://feedads.g.doubleclick.net/~a/QcpMih_aMe6eIVIYv6lltdXq-oQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/QcpMih_aMe6eIVIYv6lltdXq-oQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/QcpMih_aMe6eIVIYv6lltdXq-oQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/QcpMih_aMe6eIVIYv6lltdXq-oQ/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/ulQjDsbYAUQ" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2009/10/01/excel-2010-new-search-filter.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/DTKnIElPIn8/microsoft.office.interop.excel.pivottables.item(office.11).aspxReturns a single object from a collection. <p><a href="http://feedads.g.doubleclick.net/~a/7LYY_ML0enKhiVOAjov9ysGRXmE/0/da"><img src="http://feedads.g.doubleclick.net/~a/7LYY_ML0enKhiVOAjov9ysGRXmE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/7LYY_ML0enKhiVOAjov9ysGRXmE/1/da"><img src="http://feedads.g.doubleclick.net/~a/7LYY_ML0enKhiVOAjov9ysGRXmE/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/DTKnIElPIn8" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables.item(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/HmWaxNuqSsg/microsoft.office.interop.excel.pivottables.count(office.11).aspxReturns the number of objects in the collection. Read-only Integer. <p><a href="http://feedads.g.doubleclick.net/~a/m6istYCWjUXwAEGcJQIY59KTGZg/0/da"><img src="http://feedads.g.doubleclick.net/~a/m6istYCWjUXwAEGcJQIY59KTGZg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/m6istYCWjUXwAEGcJQIY59KTGZg/1/da"><img src="http://feedads.g.doubleclick.net/~a/m6istYCWjUXwAEGcJQIY59KTGZg/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/HmWaxNuqSsg" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables.count(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/HG-RC_-VHbY/microsoft.office.interop.excel.pivottables.getenumerator(office.11).aspxReturns an enumerator to support iterating through the collection. ... Returns an enumerator to support iterating through the collection. Namespace: Microsoft.Office.Interop ... <p><a href="http://feedads.g.doubleclick.net/~a/JMIqvtRq79FDEdEjNLmitGJj7vY/0/da"><img src="http://feedads.g.doubleclick.net/~a/JMIqvtRq79FDEdEjNLmitGJj7vY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/JMIqvtRq79FDEdEjNLmitGJj7vY/1/da"><img src="http://feedads.g.doubleclick.net/~a/JMIqvtRq79FDEdEjNLmitGJj7vY/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/HG-RC_-VHbY" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables.getenumerator(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/sd-x-nVnyH4/microsoft.office.interop.excel.pivottables.parent(office.11).aspxReturns the parent object for the specified object. Read-only. <p><a href="http://feedads.g.doubleclick.net/~a/VFARNTQQOXzyjhUqJ2_v1XJYeMU/0/da"><img src="http://feedads.g.doubleclick.net/~a/VFARNTQQOXzyjhUqJ2_v1XJYeMU/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/VFARNTQQOXzyjhUqJ2_v1XJYeMU/1/da"><img src="http://feedads.g.doubleclick.net/~a/VFARNTQQOXzyjhUqJ2_v1XJYeMU/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/sd-x-nVnyH4" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables.parent(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/_a-3kFFXseU/dd164414.aspxTeam Foundation project managers typically use Microsoft Excel to build reports from the data store in the Team Foundation data warehouse. In particular, Excel PivotTables are ... <p><a href="http://feedads.g.doubleclick.net/~a/XNHq25f4eyXmsX0-TVjo6GrSJWc/0/da"><img src="http://feedads.g.doubleclick.net/~a/XNHq25f4eyXmsX0-TVjo6GrSJWc/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/XNHq25f4eyXmsX0-TVjo6GrSJWc/1/da"><img src="http://feedads.g.doubleclick.net/~a/XNHq25f4eyXmsX0-TVjo6GrSJWc/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/_a-3kFFXseU" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/dd164414.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/kvpVaS6li0k/microsoft.office.interop.excel.pivottable(office.11).aspxRepresents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a ... <p><a href="http://feedads.g.doubleclick.net/~a/l_X9PnIZSMo5FLI1SgK_kB-egRA/0/da"><img src="http://feedads.g.doubleclick.net/~a/l_X9PnIZSMo5FLI1SgK_kB-egRA/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/l_X9PnIZSMo5FLI1SgK_kB-egRA/1/da"><img src="http://feedads.g.doubleclick.net/~a/l_X9PnIZSMo5FLI1SgK_kB-egRA/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/kvpVaS6li0k" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottable(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/kYffdvZFNuY/microsoft.office.interop.excel._worksheet.pivottables(office.11).aspxReturns an object that represents either a single PivotTable report (a PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet. <p><a href="http://feedads.g.doubleclick.net/~a/ks2fBYbfURTkVUf42fPZrv7_56E/0/da"><img src="http://feedads.g.doubleclick.net/~a/ks2fBYbfURTkVUf42fPZrv7_56E/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/ks2fBYbfURTkVUf42fPZrv7_56E/1/da"><img src="http://feedads.g.doubleclick.net/~a/ks2fBYbfURTkVUf42fPZrv7_56E/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/kYffdvZFNuY" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel._worksheet.pivottables(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/iJ-vJ0R0Wjs/microsoft.office.interop.excel.pivottables_methods(office.11).aspxName Description Add: Adds a new PivotTable report. Returns a PivotTable object. GetEnumerator: Returns an enumerator to support iterating ... <p><a href="http://feedads.g.doubleclick.net/~a/VmMoiQG9xY7tQkHLSj-wpR9Ht_4/0/da"><img src="http://feedads.g.doubleclick.net/~a/VmMoiQG9xY7tQkHLSj-wpR9Ht_4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/VmMoiQG9xY7tQkHLSj-wpR9Ht_4/1/da"><img src="http://feedads.g.doubleclick.net/~a/VmMoiQG9xY7tQkHLSj-wpR9Ht_4/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/iJ-vJ0R0Wjs" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivottables_methods(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/hBR6wwRIVJ0/pivottable-named-sets-in-excel-2010.aspxThanks to Diego Oppenheimer for putting together this post. When working with PivotTables, you often come across scenarios where you want to work with the same set of items from ... <p><a href="http://feedads.g.doubleclick.net/~a/PH6lbgAvfAUljxjgwcSl0twrMLc/0/da"><img src="http://feedads.g.doubleclick.net/~a/PH6lbgAvfAUljxjgwcSl0twrMLc/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/PH6lbgAvfAUljxjgwcSl0twrMLc/1/da"><img src="http://feedads.g.doubleclick.net/~a/PH6lbgAvfAUljxjgwcSl0twrMLc/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/hBR6wwRIVJ0" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2009/10/05/pivottable-named-sets-in-excel-2010.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/jxueh_pVfGM/104308By using this cache, Microsoft Excel can quickly calculate PivotTables and, at the same time, maintain the integrity of the original data. This cache can affect memory use ... <p><a href="http://feedads.g.doubleclick.net/~a/-4cukvOunoMhsgrXAV6H_lVto_I/0/da"><img src="http://feedads.g.doubleclick.net/~a/-4cukvOunoMhsgrXAV6H_lVto_I/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/-4cukvOunoMhsgrXAV6H_lVto_I/1/da"><img src="http://feedads.g.doubleclick.net/~a/-4cukvOunoMhsgrXAV6H_lVto_I/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/jxueh_pVfGM" height="1" width="1"/>http://support.microsoft.com/kb/104308http://feedproxy.google.com/~r/microsoft/SKdu/~3/YyIIcu2l7fM/151515Microsoft Excel 97 For more information about creating PivotTables, click the Index tab in Microsoft Excel Help or MS Excel Help, type the following text <p><a href="http://feedads.g.doubleclick.net/~a/2GxdQKqnQqqZnxDst-wl6TVNUi4/0/da"><img src="http://feedads.g.doubleclick.net/~a/2GxdQKqnQqqZnxDst-wl6TVNUi4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/2GxdQKqnQqqZnxDst-wl6TVNUi4/1/da"><img src="http://feedads.g.doubleclick.net/~a/2GxdQKqnQqqZnxDst-wl6TVNUi4/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/YyIIcu2l7fM" height="1" width="1"/>http://support.microsoft.com/kb/151515http://feedproxy.google.com/~r/microsoft/SKdu/~3/z9uI_sTKl3U/example-file-for-pivottable-data-validation-trick.aspxRecently I posted an article discussing how PivotTables can be used on Excel Services to mimick the Data Validation feature . The author, Dany Hoter, sent me a copy of the file he ... <p><a href="http://feedads.g.doubleclick.net/~a/BxYlOK-BhuIGt_bG3LgC_EnVpLg/0/da"><img src="http://feedads.g.doubleclick.net/~a/BxYlOK-BhuIGt_bG3LgC_EnVpLg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/BxYlOK-BhuIGt_bG3LgC_EnVpLg/1/da"><img src="http://feedads.g.doubleclick.net/~a/BxYlOK-BhuIGt_bG3LgC_EnVpLg/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/z9uI_sTKl3U" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2008/03/04/example-file-for-pivottable-data-validation-trick.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/_pvjg4v4kkk/bb223534.aspxReturns an object that represents either a single PivotTable report (a PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet. <p><a href="http://feedads.g.doubleclick.net/~a/wC_WPFuU27Fd1RuREwMVi7hbx4o/0/da"><img src="http://feedads.g.doubleclick.net/~a/wC_WPFuU27Fd1RuREwMVi7hbx4o/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/wC_WPFuU27Fd1RuREwMVi7hbx4o/1/da"><img src="http://feedads.g.doubleclick.net/~a/wC_WPFuU27Fd1RuREwMVi7hbx4o/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/_pvjg4v4kkk" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb223534.aspxhttp://feedproxy.google.com/~r/microsoft/SKdu/~3/PU1Bn7w7LaU/12.aspxPivotTables 9: Great support for SQL Server Analysis Services Today, I’ll start a series of articles on the improvements we’ve made to PivotTables connected to OLAP (OnLine ... <p><a href="http://feedads.g.doubleclick.net/~a/V_FBEfBrfIa34Q3sMHEDrLprZ_M/0/da"><img src="http://feedads.g.doubleclick.net/~a/V_FBEfBrfIa34Q3sMHEDrLprZ_M/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/V_FBEfBrfIa34Q3sMHEDrLprZ_M/1/da"><img src="http://feedads.g.doubleclick.net/~a/V_FBEfBrfIa34Q3sMHEDrLprZ_M/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/SKdu/~4/PU1Bn7w7LaU" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2005/12.aspx