none
MDS Excel add-in - formatting issue RRS feed

  • Question

  • Hi,

    I have a couple of fields in MDS table that I want to format as currency in Excel. Every time I am refreshing the table the formatting is removed and all numbers are shown in the Number format.

    Is there a way to preserve the formatting on refresh?

    Thanks in advance.

    Friday, April 12, 2019 10:24 AM

All replies

  • I've never been able to persist any "Excel-like" changes for MDS when viewed using the Excel plug-in.  Given that (I think) that output is from the Web Services call, I presume it's not possible.

    When users want a particular read-only view on the data -- which is most often when this occurs -- my team creates an SSRS report formatted to their specifications.

    At least for us, the number of "read-only" users greatly exceeds the number of people editing the data, so it works for us.

    Friday, April 12, 2019 12:30 PM