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