Macro 10: Refresh All Data Connections in Workbook on Open

Macro 10: Refresh All Data Connections in Workbook on Open Your workbook may have connections to external data sources such as web queries, MSQuery connections, PivotTable connections, and so on. In these cases, it may be helpful to refresh these data connections automatically when the workbook is opened. This macro does the trick. How it […]

Macro 10: Refresh All Data Connections in Workbook on Open Read More »