Steps To Manage Excel Workbook Connection Using Workbook Connections Dialog Box
These connection files are very useful to share connections on regular basis also to facilitate data source administration. Well the Connection information can be stored in a connection file or in the workbook like Universal Data Connection (UDC) file (.udcx) or Office Data Connection (ODC) file (.odc) Using this way, user can get the most updated version of their data including the changes made in the data since it was last refreshed. One can easily use the refresh option to extract the updated data from their workbook.
EXCEL PIVOT CHART LOSES CONNECTIONS HOW TO
Basically this data connection in Excel contains set of information about how to log in, query, locate, and perfectly access the external data source.Īfter connecting your excel workbook with external data source. Using the data connection in Excel, external data sources are well connected with Excel workbook.