How to enable Pivot Table What-If Analysis option

%3CLINGO-SUB%20id%3D%22lingo-sub-1440484%22%20slang%3D%22en-US%22%3EHow%20to%20enable%20Pivot%20Table%20What-If%20Analysis%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440484%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20tell%20me%20how%20to%20enable%20Pivot%20Table%20What-If%20analysis%2C%20located%20under%20PivotTable%20Analyze%20%26gt%3B%26gt%3B%20Options%20%26gt%3B%26gt%3B%20Data%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LW2016_2-1591280626369.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F196502i620ECB07715827FC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22LW2016_2-1591280626369.png%22%20alt%3D%22LW2016_2-1591280626369.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20have%20enabled%20the%20default%20setting%2C%20located%26nbsp%3Bunder%20File%20%26gt%3B%26gt%3B%20Options%20%26gt%3B%26gt%3B%20Data%20%26gt%3B%26gt%3B%20Edit%20Default%20Layout%20%26gt%3B%26gt%3B%20Pivot%20table%20options%20%26gt%3B%26gt%3B%20Data.%26nbsp%3B%20I%20am%20using%20an%20external%20data%20source%20and%20have%20%22load%20to%20data%20model%22%20unchecked.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LW2016_1-1591280548564.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F196501i99F4516C818B8FAA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22LW2016_1-1591280548564.png%22%20alt%3D%22LW2016_1-1591280548564.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20also%20do%20not%20have%20Calculated%20Items%20available%2C%26nbsp%3Blocated%20under%20PivotTable%20Analyze%20%26gt%3B%26gt%3B%20Fields%2C%20items%20%26amp%3B%20sets.%26nbsp%3B%20Calculated%20field%20is%20available%2C%20but%20not%20calculated%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Office%20365%20for%20Enterprise.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1440484%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Can anyone tell me how to enable Pivot Table What-If analysis, located under PivotTable Analyze >> Options >> Data?

LW2016_2-1591280626369.png

I have enabled the default setting, located under File >> Options >> Data >> Edit Default Layout >> Pivot table options >> Data.  I am using an external data source and have "load to data model" unchecked.

LW2016_1-1591280548564.png

I also do not have Calculated Items available, located under PivotTable Analyze >> Fields, items & sets.  Calculated field is available, but not calculated item.

 

I am using Office 365 for Enterprise.

 
 

 

 

 

0 Replies