January 30, 2020 at 7:38 pm
Hi Experts,
I did setup Microsoft SQL Server 2016 Master Data Services (MDS) successfully but hitting an error (bug?) while installing the add-in for Excel - which can download/upload data from/into MDS repository, respectively.
Please find the error message screenshot attached - Seems like a compatibility issue between Excel 365 and MDS 2016. But the download page doesn't mention anything specifically about it.
Could anyone please advise if there is any work around for this compatibility issue? Or, if I'm hitting a bug?
(Note: I'm having - MS Office 365, MS SQL Server 2016)
Thanks
Ranit
January 30, 2020 at 7:50 pm
is your installed excel version a 64 bit?
January 31, 2020 at 9:28 am
Hi Frederico,
Just checked and it is -- Microsoft Excel for Office 365 MSO 32-bit
Does that mean, incompatibility between 32-bit MS Office and 64-bit MDS is the actual cause of this problem?
Could you please advise the best way(s) to mitigate this problem?
(ps. Reckon upgrading Office to 64-bit is not a viable option at this point)
January 31, 2020 at 10:14 am
There is a 32bit version of the plugin
https://www.microsoft.com/en-us/download/details.aspx?id=52677
There was a time MS advised installing 32bit office over 64bit, but think those times are over. Depends what your IT teams will allow you to install in terms of Office. If corporate policy is 32bit, then you need to get the x86 plugin from the above link.
January 31, 2020 at 11:42 am
Hi Anthony,
Thanks for your response.
I am exactly trying the same now -- x86 plugin. It's not reflecting in Excel yet, reckon needs a system reboot.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply