In that article, I explained the benefits of the GETPIVOTDATA function, but I also should have mentioned that you can disable the GETPIVOTTABLE functionality in Excel 2010 and 2007 as follows: a.