To enable external data connection in Excel, you need to open the Options wizard and go to the Trust Center Settings. Then, head to the External Content tab and find the Security settings for Data ...

When you have duplicate data that you want to remove from a single column in your dataset, start by clicking into the column you want to dedupe. 1. Click "Data" in the top menu of the Excel window ...