2
We have a couple of issues that might be bugs. At least we cannot find any fixes or help on the web. We have an Excel sheet with a sheet per Entity. All data comes from the same MDS.
First problem
When we close the spreadsheet and open it again. We connect to MDS again but it is like some of the tabs/sheets does not connect again. The refresh button and publish button is greyed out (see screenshot - I have scrolled away from all the sensitive data). Any tips to fix this would be great!
Second problem
When above fails we would try to refresh the data fully from the MDS Explorer in Excel. However then it renames the sheet-tab and adds a number "1" at the end? (See Account 1 in screenshot) Is there any way to control this as renaming screws up the sheet for us?
Third Problem
This is harder to explain and it is a periodical problem - I cant find any way to really trigger it. So I just hope someone have seen this as well and found a fix for it. What happens is, while scrolling in one of the Entity sheets suddenly the first two lines which normally is split and freezed suddenly starts scrolling with data from the same sheet? So if you see the screenshot and imagine the 1-2 suddenly shows row 1050-1051 and scrolls as well with the normal rows.
Hard facts about the systems:
<pre>
DatabaseSchemaVersion
13.1.0.3
SQLServerVersion
Microsoft SQL Server 2016 (SP1-CU5) (KB4040714) - 13.0.4451.0 (X64)
Sep 5 2017 16:12:34
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: ) (Hypervisor)
ProductVersion
13.1.0.3
CompatibilityLevel
110
OSVersion
Microsoft Windows Server 2016 Standard
Excel Version
16.0.4705.1000
Excel Add-in Version
13.0.5150.0
</pre>
So please any help, pointing in the right direction, or explanation will be received on my knees kissing your hands :)
buhg
Posted 2018-06-14T08:09:41.777
Reputation: 21
1What use is a full screen screenshot that contains mostly empty cells? What is MDS? You apply the tag, but it does not have a description. Is the tag even about your interpretation of MDS? It seems that you are using some 3rd party software inside Excel, because the "Master Data" ribbon is not part of Excel out of the box. If you run into problems with that product, your first port of call should be the support service for that product. I've been working with Excel questions in forums for over 10 years and have never come across this product, so it's not very common. – teylyn – 2018-06-14T08:25:50.303
Well ... First of the "3rd party tool" is actually Microsofts own add-in for excel. I am new to mds I figured was Master Data Services - But if this isnt the case - then I dont know where to go. No it is not a very common product as it is a fairly new technology from Microsoft. – buhg – 2018-06-14T09:06:00.113