delete-a-row-mds-add-in-for-excel.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Delete a Row	Delete a Row (MDS Add-in for Excel)	CordeliaGrey	jiwang6	03/01/2017	sql	master-data-services	how-to	microsoft-excel-add-in

Delete a Row (MDS Add-in for Excel)

[!INCLUDE SQL Server Windows Only - ASDBMI]

In the [!INCLUDEssMDSshort] [!INCLUDEssMDSXLS], delete a row of data (a member) from the MDS repository when you no longer want it to be available to users.

Note

Administrators can reactivate deleted members. For more information, see Reactivate a Member or Collection (Master Data Services).

Prerequisites

To perform this procedure:

• You must have permission to the Explorer functional area.

• You must have an active worksheet that contains MDS-managed data.

To delete a MDS-managed row of data

1. Select the entire row you want to delete by clicking the row heading.

2. In the Publish and Validate group, click Delete.

3. On the confirmation dialog box, click Yes.

See Also

Overview: Importing Data from Excel (MDS Add-in for Excel)