connections refresh

I have a very simple piece of VBA which sets some slicers, refreshes a connection and puts a message on the status bar, but I have noticed one message doesn't go away. This connection is not critical to the running of the spreadsheet as it just gives an overview when required - usually on by...

Hi, I recently watched the MrExcel YouTube Video about the built-in exchange rate function in Excel (link below). It's very useful but currently has a drawback that to refresh the rates the only way possible seems to be Refresh All which really slows Excel down, is there a way to just refresh...

Hi! I was tasked to create a relatively simple series of excel workbooks that connect to a main workbook. I have several different districts that are gonna have their own budget workbook aswell as a report workbook from which the person in charge of that district can send out a small report...

I have a table that is connected to to data in another excel spreadsheet using Microsoft Query. The Query takes information in Spreadsheet 1 on the source Workbook and joins it to data on Spreadsheet 2 in the source Workbook then updates my table in the Report Workbook. I have re-arranged the...

Hello Excel Community, I have connected one spreadsheet to the main spreadsheet (MASTER) by using the DATA tab, but I'm having issues because I would like the spreadsheet to look exactly like MASTER (including formatting & conditional formatting). Anyway I can do this without VBA coding since...

For many years we were able to automatically update the connection to a database and refresh the data on the spread sheet. We used: With ActiveWorkbook.Connections("Query from Calibration Data").ODBCConnection.Connection = "ODBC;DSN=Calibration Data;UID=<valid_id>;PWD=<valid_password>"...