Recommended Pivot Table Feature

Joe Stich

New Member
Joined
Dec 1, 2015
Messages
1
Just bought Pivot Table and Data Crunching.
On page 31, bottom, it reads, "Place your cursor in a tabular range of data and then click the Recommended Pivot Tables icon."
the data file i downloaded was not the exact one as is in the book, but I followed it and seemed to be on track.
At this point no matter where I place my cursor the icon remains gray and unusable.
Following direction, for me is cumbersome at best, but when I am trying to closely follow what is presented in the book and my screen does something else, i am at a loss to what the next step should be.
Any suggestions would be appreciated.
Regards
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Even on a blank sheet, the button should work..
Are any other buttons on the Insert tab greyed out? If so - the sheet could be protected.
My other idea is that if you downloaded the file, it may be in Protected View, which severely limits what you can do with the workbook.
 

Forum statistics

Threads
1,214,805
Messages
6,121,665
Members
449,045
Latest member
Marcus05

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top