Excel CUBE Functions can do everything a PivotTable does and more!

Convert a pivot table to Excel formulas: Select a cell Pivot Table Analysis, OLAP Tools, Convert to Formulas