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

Chapter 9. Using External Data Sources f... > Importing and Using External Data Wi...

Importing and Using External Data Without the PivotTable Wizard

You have just successfully built a pivot table that analyzes more than 80,000 rows of data. This would be impossible (or at least difficult) to do with local data. The reason you were able to do this is that you brought external data directly into your pivot cache using the PivotTable Wizard. By bringing external data directly into a pivot cache, you avoid the physical limitations of a spreadsheet.

The drawback to using the PivotTable Wizard to bring in external data is that you won't have immediate access to detailed records. That is, your raw dataset is not hard-coded onto a spreadsheet where you can AutoFilter it, see items not in your pivot table, or perform any number of other actions against it. Luckily, as with most actions in Excel, there is more than one way to bring in and use external data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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