Why is my pivot table option greyed out?

Why is my pivot table option greyed out?

If all buttons are greyed out, it certainly looks like the workbook is shared or the sheet protected. Otherwise, it might be a one-time glitch.

Why can’t I add a slicer to my pivot table?

Click PivotTable Analyze on the menu. Click Insert Slicer (it’s not greyed out, and does bring up the dialog) Choose my field (it is a field that’s included in the pivot table) Click OK.

How do you activate a slicer in a pivot table?

To add a slicer, click a cell in your PivotTable, and the PIVOTTABLE TOOLS tab appears. Click ANALYZE, click Insert Slicer. The Insert Slicer dialog box has options for each field in the PivotTable. Check the fields you want to slice the PivotTable with, and click OK.

How do you unlock a slicer in Excel?

Unlock Slicers

1. Right click on a slicer and select Size and Properties.
2. On the right side of the screen a Format Slicer menu will appear. Click the triangle next to Properties.
3. Uncheck the box next to Locked.
4. Follow the same steps for the second slicer.

Why is calculated field greyed out?

It is grayed out because the source is OLAP, however there is a work around. Drop the data into Excel into a table. If you try to pivot off this data, the calculated field will still be grayed out.

Why is slicer not available in Excel?

Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed. You can use a slicer to filter data in a table or PivotTable with ease.

How do you unlock the greyed out menu in Excel 2016?

Make sure you are not in Edit mode by hitting Esc (Escape key), as edit mode >will gray out a lot of menu options — notably most Edit options (except cut >& paste). Will grayout Options under Toolbar; many options under Data and >under Window.

Can we use slicer without pivot table?

The chart data and the values in G1:G13 will change based on the selected Cost Center from the slicers list as can be seen the data in the range B1:F13 can be filtered with a slicer without inserting a Pivot Table.

How do I fix the slicer in Excel?

To fix the position of a slicer in a sheet, just do the following:

1. Right click the slicer, and then click Size and Properties.
2. On the Format Slicer pane, under Properties, select the Don’t move or size with cells box.

Why can’t I move my slicer in Excel?

Select Size and Properties in the menu. A task pane appears. In the Format Slicer task pane, click the arrow beside Position and Layout to expand it. Check or select Disable resizing and moving.