Forum Discussion

Copper Contributor

Aug 22, 2017

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

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-defau...

excel

Franz Lurvink

Copper Contributor

Jun 04, 2018

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

SergeiBaklan

Diamond Contributor

Jun 04, 2018

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-9db2-4f2912a0f94e

cabrijesh
Copper Contributor
Apr 12, 2020
SergeiBaklan
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.
- PARKAVE1016
  Copper Contributor
  May 03, 2022
  Was there a fix found for missing file>options>data capability?