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

Chapter 9. Using External Data Sources f... > Creating Dynamic Pivot Table Reporti...

Creating Dynamic Pivot Table Reporting Systems

One of the more useful ways to utilize imported external data is in the creation of a dynamic reporting system. What does that mean?

Imagine for a moment that you have distributed, to 10 users, an Excel workbook that consists of one pivot table report. This report provides data on weekly sales. If your pivot table uses a data source within the Excel workbook, you have essentially given your users a static report. Although it is true that the pivot table is dynamic in and of itself, it will never show new data because the source data used to feed the pivot table is hard-coded locally. The bottom line is that every week, you will have to distribute a new weekly sales report to the same 10 users with the latest data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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