VBA / Macros Archives

Category: VBA / Macros

Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros

Excel 2013 public preview (aka beta) is out, which means that now we’re not only playing around with PowerPivot V2 and Power View V1, but now we have another new set of toys to take for a spin.

Written by Kasper on July 26, 2012

Auto-Modify Every Pivot in a Workbook

It’s been awhile since I’ve talked about Macros (also known as VBA). I think it’s overdue. Macros are nothing short of amazing. We couldn’t live without them at Pivotstream

Written by Rob Collie on March 6, 2012