Frank Rice published an article on MSDN: Programmatically Update Multiple External Data Connections in Excel 2007 by Using Open XML
Wouter van Vugt blogged on copying a chart from a spreadsheet to a presentation.
After posting on splitting runs in word processing documents, I realized that I had neglected to account for content controls in the transform. I’ve updated that post with the corrected code. I also included an explanation of the markup that requires a recursive approach.