locked
How to update the source data behind a data connection in a Data Model? RRS feed

  • Question

  • Hi there,

    I used the "Data Model" option when building a pivot table using data on a "CMPL" data worksheet. The "Definition" behind the connection shows "COMPL" by clicking Data ---> Connections ---> Properties ---> Definition

    Note both the data worksheet and the pivot table are in the same Excel workbook.

    Question - next time when I update the "COMPL" data worksheet will the pivot tables be updated?

    The connection name is "WorksheetConnection_v8_FINAL_CMPL_201905_20190618.xlsx!COMPL". If I save the file with a different name using the same connection will it point to the new data?

    Wednesday, June 19, 2019 3:01 PM