Refreshing Data (MDS Add-in for Excel)

In Master Data Services Add-in for Excel, refresh data when you want to get the latest information from the MDS repository without opening a new worksheet. You can refresh either all cells or a selection of cells. This can be useful when you have inserted columns with custom formulas or other data that is not managed in MDS and you want to preserve it.

When You Can Refresh MDS-Managed Data

You can refresh MDS-managed data in an active worksheet if the active worksheet already contains MDS-managed data. If you have changed attribute values or added members to the worksheet, you must publish your changes before you can refresh.

Refreshing a Selection

You have the choice of refreshing all cells or refreshing only selected cells. The selected cells must be contiguous. If a set of contiguous cells is selected, all MDS managed cells in that set will be updated to display the values currently stored on the server. Unchanged rows and columns that are not managed by MDS are not affected in any way.

What Happens When You Refresh MDS-Managed Data

When you refresh data in the Add-in for Excel, what happens to the MDS-managed data in the sheet depends on what has changed in the MDS repository since you last loaded the data.

  • If new members have been added to repository, they are added to the end of the worksheet and are highlighted in green.

  • If members were deleted from the repository, they are deleted from the worksheet.

  • If an attribute value has changed in the MDS repository, the value in the worksheet is updated with value from the MDS repository. The cell color does not change.


  • In the active worksheet, if non-managed data exists in rows beneath the MDS-managed data, the non-managed data may be overwritten. This occurs when you refresh the sheet and new rows of MDS-managed data, which overlap with the non-managed data, are added.

  • When you refresh, comments on MDS-managed cells are deleted.

How to Refresh MDS-Managed Data

In the Connect and Load group on the ribbon, the Refresh button has two options, Refresh All and Refresh Selection. The default action of the ribbon button is Refresh All. To refresh the entire sheet with values from the server, click the Refresh button or choose the Refresh All option. To refresh only some of the cells in a sheet, select the cells (must be one contiguous selection) and choose the Refresh Selection option.

Task Description


Create a connection to a Master Data Services database.

Connect to an MDS Repository (MDS Add-in for Excel)

Load MDS data into Excel.

Load Data from MDS into Excel