1 Reply Latest reply on Apr 15, 2016 2:27 PM by Stephen Lapic

    Update Custom Property Cells in Excel

    Steve Reinisch
    Steve Reinisch Apr 15, 2016 10:05 AM

      We have an Excel template that links to custom properties in an Office Data Card. All the fields populate in excel but here is the problem:

       

      Only 1 sheet of the template in Excel update with the custom properties, I cannot figure out how to get the same custom property in identical sheets in the Excel file to populate as well.

       

      Possibly not an EPDM problem but hoping someone here may know the answer.

      • 840 Views
      • Categories: Data Management, Enterprise PDM
      • Tags:
        • Re: Update Custom Property Cells in Excel
          Stephen Lapic
          Stephen Lapic Apr 15, 2016 2:27 PM (in response to Steve Reinisch)

          We had the same problem, it would only work on the first sheet.  So what we did was to fill the cells on the first sheet from the variables and then link the cells on the other sheets to the first sheet.  This way they would update automatically.

           

          Another problem we came across was that you must save the file with the first worksheet selected otherwise the link tended to break between the custom properties in the first worksheet and the variables in EPDM.  Once that link broke it couldn't be repaired and any changes to the variables had to be put in manually.