Key to dynamic dating
Using the partitioning methods described in this section can help you tune SQL statements to avoid unnecessary index and table scans (using partition pruning).You can also improve the performance of massive join operations when large amounts of data (for example, several million rows) are joined together by using partition-wise joins.
This chapter discusses partitioning, a key methodology for addressing these needs.
If you’re simply looking for where you define or modify named ranges in Excel 2010 (as one commenter indicated in response to an earlier version of this update), it’s on the Formulas tab in the Defined Names area — Name Manager.
If you are looking for other Excel 2010-specific information that this post doesn’t cover, please leave a quick comment as to what the change/issue is that led you to the search.
Someway to constrain the depth to which array_replace_recursive can go?
I’ve made a new version of the post that takes advantage of Excel tables, which simplified the process a bit (it’s still kinda’ complicated).
Now for some major clean up as we do not need the axes, titles or legends for this. We are now ready to work on the presentationdescription of the xml.