It provides a central place to see all of the data connections in a workbook, see where they are used, and modify, remove or refresh each one individually. One of the biggest improvements to working with external data connections in Excel for Windows in recent releases has been the Connection Manager. A better way to work with external data connections Looking for that Refresh button? It’s on the Data tab just as you’d expect.
In addition, all of the ways in which you interact with external data are now consistent between the platforms.