Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. For more information, visit www.datapigtechnologies.com . So summer is for practically over and I'm back to blogging topics that can actually help people. For my first post back, I'll come out big with one of the best pieces of code I've ever written. A few weeks ago Dick Kusleika posted a small but brilliant piece of code that auto formats the Read More...
Read the complete post at http://blogs.msdn.com/b/excel/archive/2010/09/21/auto-format-pivottables-to-match-source-data-power-tips-series.aspx
Sep 21 2010, 08:31 PM
Microsoft Excel 2010