The motivation for this quick and incomplete draft was Dick Kusleika’s post on distributing/communicating a PivotTable template (http://www.dailydoseofexcel.com/archives/2008/05/21/pivottable-markup-language/).
In the approach I’ve adopted for the past few years, the basic idea is to separate the data from the analysis and presentation. Then, a simple piece of code lets one update the data connections in [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2008/06/20/using-an-analysis-template-updating-the-data-source/
Posted
Jun 21 2008, 01:56 AM
by
Daily Dose of Excel