Excel 2016 Home and Office compatibility issues with "My Cash Flow Template"

Copper Contributor

Hi, 

I'm having an issue with the "My Cash Flow" Template

The application cannot be edited. So I can't add my data.

The instructions for adding "Power Pivot" Don't work and/or are incompatable with Excel 2016 Home and office.

Is anyone else having this problem?

Can an editable version of the Template be downloaded?

Are there any updated instructions to make it compatible with my version of Excel?

 

1 Reply

Hi Thomas,

 

I guess you mean this Learn how to use the My Cashflow template with Excel 2016 template. Yes, Power Pivot is available only for Enterprize subscriptions of O365 and standalone ProPlus Where is Power Pivot? 

On the other hand you may use the template as it is. And even with Excel 2016 Home you may edit/add measures if unhide FieldList in ribbo PivotTable Tools ->Analyse. Right click on exisiting measure to edit it, or right click on table name to edit new measure.

EditMeasure.JPG