question

BrianEngelbrechtAndersen avatar image
0 Votes"
BrianEngelbrechtAndersen asked JamieMount-4483 answered

Critical errors in Master Data Services Add-in for excel

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@BrianEngelbrechtAndersen
As threads with tag "office-excel-itpro" focus more on general issues of Excel, but I think your issue is more related to this Add-in, so I would remove the tag.
Thanks for your understanding.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered JamieMount-4483 commented

Hi @BrianEngelbrechtAndersen,

Cannot specify the Locked property for the Range class.

It seems some people have the same issue with you, they submit this issue to the Microsoft feedback, you can vote this feedback. Unfortunately there is no solution for this feedback. MDS 2019 and MDS 2019 Add-Inn error: unable to set the locked property of the range class

the current cell title was not found. if the column title was changed, close the sheet and try again"

You can also vote this feedback that someone has the same issue with you.

MDS 2019 and MDS 2019 Add-In error: The current cell column title was not found. If the column title was changed, close the sheet and try ag

Best regards,
Cathy


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

That link does not work.

0 Votes 0 ·
PaulDunleavy-8534 avatar image
0 Votes"
PaulDunleavy-8534 answered

Hi,

Was the MDS 2019 Excel Adin error:

Cannot specify the Locked property for the Range class.

ever addressed by Microsoft? I'm seeing this quite a bit by some of my users. It requires killing Excel in the task manager to get around it.

This link is dead.

https://feedback.azure.com/forums/908035-sql-server/suggestions/41585917-mds-2019-and-mds-2019-add-inn-error-unable-to-set

I'm happy to send screen shots, and error logs if it helps.

Thanks!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JamieMount-4483 avatar image
0 Votes"
JamieMount-4483 answered

We are having this issue as well. SQL Server 2019, MDS Excel Add In gets this error on a daily basis. It is extremely frustrating.

"Unable to set the Locked property of the Range class"

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.