Hi,
Im experiencing some critical errors with Master Data Service Add-in for excel.
Error 1:
When i Publish changes to an main entity i get the below error.
Note: The main entity are using several domainbased entities as well as normal text fields.
Two fields are also using inherited hierarchy for a "User" with a "Position". This means i need to select the position, then the user. Works fine until publish.
===================================
Cannot specify the Locked property for the Range class.
Program Location:
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
at Microsoft.MasterDataServices.ExcelAddInCore.DataView.<>c_DisplayClass78_1.<PublishAll>b_7(IAsyncResult ar)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
It's impossible to use this main entity because this error happens every time and freezes Excel.
I have reinstalled the Add-in.
Im using MDS Version 15.0.2000.5
Office Sdt. 2016
Error 2:
I have a second "Main" Entity for an organization with Company, Division, Department.
All three fields are domainbased entities.
When selecting company and Division it works fine, but when selecting the Department i get this error:
"the current cell title was not found. if the column title was changed, close the sheet and try again"
Any help appriciated