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,
Check in Customize Ribbon if Data is checked
That functionality was introduced here
https://technet.microsoft.com/en-us/office/mt465751.aspx, check your version and build.
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 !
Yes, that's deferred channel, new functionality appears here far behind other ones