Data Model does not refresh data RRS feed

  • Question

  • Hello all,

    I have been looking for a solution quite some time now and was not able to find a solution unfortunately.

    Following issue:

    I created a pivot table using the data model in order to make a distinct count on an attribute.

    This works fine as long as I do not leave the file. When I update the data which the pivot table is based on (by overwriting the old data), it does not refresh the data in the pivot though.

    When I execute the "manage" button in the Power Pivot Tab, the "Refresh" Button for this table is greyed out as well.

    This only happens after reentering the file - as long as I do not leave it, everything works fine. But as soon as I close it and open the excel file again, the updates do not work anymore, even if I do not overwrite the old data I am unable to perform a refresh in general. 

    Am I missing something? Appreciate any feedback, thank you in advance!

    • Edited by Richi7007 Monday, January 6, 2020 4:00 PM typo
    Monday, January 6, 2020 4:00 PM