connections refresh

  1. M

    Message after Connection has refreshed

    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...
  2. S

    Excel Built-In Exchange Rate

    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...
  3. N

    Value Error when activating content/updating content from other workbooks

    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...
  4. T

    Connection Refreshed Changing Non-Connected Columns

    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...
  5. J

    connecting worksheet

    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...
  6. B

    activeworkbook.connections refresh stopped working

    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>"...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top