• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Using External Data Sources f... > Building a Pivot Table Using Externa...

Building a Pivot Table Using External Data Sources

The general idea behind building your pivot table using an external data source is that you can create and use a pivot cache from a set of data that is not located in your Excel workbook. This means you can create a pivot table without one cell of data in your Excel workbook! Although there are many ways you can apply external data sources, one of the main benefits from this functionality is the ability to work around Excel's data management limitations.

Working Around Excel's Data Management Limitations

There is no argument that Excel is very good at processing and analyzing data. In fact, pivot tables themselves are a testament to the analytical power of Excel. However, with all its strengths comes one noticeable weakness. Excel makes for a poor data management platform—primarily for three reasons:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint