Convert to Range tool is not active

[gordvera]

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

[#2]

@gordvera 

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.