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...
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)
Looks as if my company is running an older version, despite having "automatic updates" on. Thank you !