1 Reply Latest reply on Mar 3, 2014 9:22 AM by Jake Brann

    Updating linked EPDM variables into locked Excel cells

    Jake Brann

      Hopefully someone has a simple solution to this.

       

      I have setup an Excel workbook to link some variable fields from the EPDM datacard.

       

      Everything works great - however, I of course want more...

       

      Some of the fields on the datacard are read only and I want the same level of protection in Excel.

       

      I have tried locking the cells and protecting the sheet in Excel, but those particular locked cells don't update with the variable information.

       

      I have been researching and it looks like there may be a way to unprotect and protect the file via an auto open vb macro.  Not sure how it would work though.

       

      Has anyone had a similar problem and found a solution?

       

      Thanks,

      Jake