Excel 2016 - data manager button missing from data tools?


  • Excel 2016 at home does not have Data Manager green button on the Data Tools ribbon. How can I add this? I need to finalise a report to submit for my degree and cannot complete without loading the data table and updating some of the DAX. I can see the data model is in the sheet via the pivot tables/charts. I've tried activating all the available add-ins but nothing is helping. How do I open the Data Manager without a button??  Please help I'm not working now and have no access to Excel professional. Thanks.

    Tuesday, May 8, 2018 9:28 AM