Home Forums SQLServerCentral.com Anything that is NOT about SQL! How to mark an Excel cell as changed so its value will be published to Master Data Services? RE: How to mark an Excel cell as changed so its value will be published to Master Data Services?<!-- 864 -->

  • It looks like I figured it out.

    I had Application.EnableEvents set to False in the code which was preventing the cells to be marked as changed for MDS. I simply put Application.EnableEvents = True before the code that populates the cells with the data. Now the newly populated cells are highlighted and ready to be published to MDS.