Forum Discussion
sofiamatsson
Oct 28, 2020Copper Contributor
Template not working on Excel 365 on Mac
https://templates.office.com/en-us/family-budget-monthly-tm16410230 The information in this template will not update as expected, and attempting to update some information gives a 'This PivotTabl...
Riny_van_Eekelen
Oct 28, 2020Platinum Contributor
sofiamatsson On a Mac myself. Downloaded the template and got the same message. It's because Excel for Mac does not support Data Model. Its part of the more advanced features like Power Query and Power Pivot. Not available for Mac users I'm afraid.
Create the pivot table yourself and get rid of the one created on the template. See attached file Sheet1.
- sofiamatssonOct 30, 2020Copper Contributor
Riny_van_Eekelen Alright, thank you for your help! I'll try to do that, and hopefully it will work better.