Convert to Range tool is not active

Occasional Visitor

I was trying to conert a Pivot table into a range following the instuctions here Convert an Excel table to a range of data ( but for some reason it´s not there and when I add it manually, the funcion is not active. 





1 Reply


Convert to Range applies to tables created by clicking Table on the Insert tab of the ribbon, not to pivot tables.

You can do the following instead:

  • Select the entire pivot table.
  • Copy it.
  • Click the lower half of the Paste button on the Home tab of the ribbon and select Values.