Forum Discussion
"Data" not an option under excel >file> options.
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
Thomas, check Data under Advanced menu. Depends on build it could be here.
Hi It's not there could you specify where to find the data option?
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
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.
