locked
Excel Add in Giving error "Unable to set the NumberFormat property of the Range Class" RRS feed

  • Question

  • Hi 

    I have a very simple model with two entities. 

    One with Clients and on with Client Types. The client Type is set on the clients with a Domain based column. 

    I have a custom business rule, that checks if the Client Number is a valid client number and if it is, I fill out the ClientName. 

    This all works as supposed to, but when I publish I get an error saying "Unable to set the NumberFormat property of the Range Class" and the new row(s) stays as edited. If I refresh the sheet everything is ok, and the data has been published. 

    So far I think it looks to be a problem in Excel, but I can't seem to figure out what it is? 

    My Excel is in danish by the way. 

    Wednesday, November 15, 2017 9:39 AM