1 Reply Latest reply on May 18, 2015 9:08 PM by Lawson Jones

    Linking Variables to Excel - Check Box

    Katie Hughes

      I am trying to create a new template in EPDM where it creates a new excel file and connects the variables on the file data card to named cells in excel.  I have been able to link all of the variables on the data card (thanks to this webpage!), but I can't seem to get the check boxes to link.

       

      I named the cell the same as the variable name.  Then I went to the excel properties and made sure that the variable was able to "Link to content".  I saved the excel file and went to my data card to put a check in the checkbox. I checked the box, saved the data card and went back into my excel file.  Nothing was showing up in the cell, so I went back to the custom properties tab in the excel properties and noticed the the link was no longer there.  There was a 1 next to the variable, but no link.

       

      Has anyone run into this before?  I've tried other check boxes and they do the same thing.  I tried changing the format of the cell in excel, changing the variable type in PDM, but nothing seems to work.  I could change it to a drop down, but I think it would be a lot more straightforward for users if it were a checkbox.

       

      Thanks for your help! It is very much appreciated.