Forum Discussion
"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...
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.
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.
- Was there a fix found for missing file>options>data capability?
