What happened to the ability to create a pivot table using the Multiple Consolidation Ranges option?
That option still exists, but you need to add the ‘PivotTable and PivotChart Wizard’ command to the Quick Access toolbar (Found in ‘Commands not in the Ribbon’), and use that command to start a new pivot table. Q: I can’t find the command to apply names to cell references in a formula. In Excel 2003, the command was Insert / Name / Apply. A: The Define Name control in the Formulas / Defined Names groups is a drop-down. Click the down-arrow, and you’ll see the Apply Names command.
