Have any of you seen the new Powerpivot function in Excel 2010? I took the
tutorial here http://technet.microsoft.com/en-us/library/ff452206.aspx
this is such a valuable tool for combining various excel spreadsheets from
various databases into one Pivot Table/Chart.
Hope this info finds interest
wow...
"everyone knowledgeable knows that VBA performs slow when compared to inbuilt
Excel functions"
I guess my 18 years and 80,000 lines of VBA code don't qualify as
"knowledgeable".
Whenever possible, I try to use VBA code because I can get it done faster than
inbuilt Excel functions!
I ha
