Microsoft Office Tutorials and References
In Depth Information
• PivotTables rely on SQL queries that can have subtle differences
between two queries written by two different people. This
increases the likelihood that two reports that logically should
• External data typically isn’t available from IT.
When PivotTables link to large files over the network, the response
time can be quite slow.
Excel formulas only can reference data that PivotTables return to
spreadsheet cells. This forces Excel users to interact with
PivotTables to update their data, rather than interacting only with
Method 4: Excel-Surly OLAPs
Many OLAP database products are on the market. Most of them
aren’t Excel-friendly. I call them Excel surly .
Excel-surly OLAPs lack at least one of two key features offered by
First, Excel-surly OLAPs write data as values to cells in Excel. They
push data into Excel. On the other hand, Excel-friendly OLAPs
return data using spreadsheet formulas. They pull data from OLAP
cells into Excel.
The pull approach is much more powerful than the push approach,
and easier to use:
• Using formulas leaves your spreadsheet in control. To report
some other month, or some other department, you just change
the month and department values in their respective cells and