"Data" not an option under excel >file> options.

[Jason Drouillard]

Cannot set pivot table defaults do to missing options "data". see screen shots of actual vs. should be. all updates installed. tutorial ( https://support.office.com/en-us/article/Set-PivotTable-default-layout-options-efd8569c-f07a-43c1-9d...) does not work.

[#2]

Hi Jason,

Check in Customize Ribbon if Data is checked

That functionality was introduced here

https://technet.microsoft.com/en-us/office/mt465751.aspx, check your version and build.

[#3]

Hello,

Data was checked. The data is not missing from the tool bar/ribbon, but actually missing from excel options itself where you are to change defauts etc.

\

Running version 1701 9Build 7766.2099)

[#4]

Looks as if my company is running an older version, despite having "automatic updates" on. Thank you !

[#5]

Yes, that's deferred channel, new functionality appears here far behind other ones

[#6]

Hi Jason, I'm having the same issue here where "Data" in the in the File, Options menu.

How did you get it to appear?

Thanks,

Thomas

[#7]

Thomas, check Data under Advanced menu. Depends on build it could be here. 

[#8]

Hi, I have the same issue. The "data" option is missing in my Office 2016 prof. pro Excel version and therefore I cannot fix the pivottable settings. It is not in "advanced" or any of the other categories either. Any ideas what happened?

Best regards

Franz

[#9]

Hi Franz,

Note: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office. 

Please see https://support.office.com/en-us/article/Set-PivotTable-default-layout-options-efd8569c-f07a-43c1-9d...

[#10]

@Sergei Baklan 

Excel 2016

1. Data under File>option missing.

2. Get External Data > From Web> Basic Advance option missing.

3. Excel updated

I want to go to advance settings under get data from web. While going through couple of suggestions on the internet, someone suggested to turn on legacy data option under file>options>data. This is also missing. Can you please help.

[#11]

Was there a fix found for missing file>options>data capability?

[#12]

@Sergei Baklan 

Hi It's not there could you specify where to find the data option?