refreshall

  1. M

    Refresh All button vs button tied to .RefreshAll method

    I have a VBA project that will crash if I click the Refresh All button found on the DATA tab on the Excel ribbon. However, if I create a button and tie it to ThisWorkbook.RefreshAll, the project works perfectly. Why might this be?
  2. G

    RefreshAll ODBC

    [CODE]I have a pre-configured ODBC connection and come up with the Macro below to REFRESH data. It is working fine but if I am using a workstation that is not configured to ODBC I got an error. I need a revision on the code below to trap the error, instead of an error there will be a message...
  3. K

    VBA / Refresh all data in a workbook with sql data sources automatically.

    Hello! I am new to this forum, and also new to VBA. I am doing a daily report, that is supposed to send automatically every day as pdf to the managers in my company. The report consists of pivot tables and charts, that mainly use an external data source (SQL database). I created the pivot...
  4. A

    Refreshable Excel

    Hi Team, I manage a small team with 5 members in it. I want to create an excel sheet (tracker) of their daily activities. I want a master excel sheet also. So, when they update anything in their excel sheet, I should be able to see it in my master excel sheet. I do not have any Sql Server so...
  5. S

    Code completes before "refreshall" completes

    Here are a few lines of my code: ActiveWorkbook.RefreshAll Call populateComboBox MsgBox ("Done!") The combobox on line 2 is populated with data that is refreshed on line 1. Only problem is, line 2 doesn't wait to execute until line 1 is complete. So, my combobox is populated and...
  6. E

    I Need help edit macro

    hi my friend plz help me i need edit this macro RefreshAll and auto save every 5 min Sub auto() ' ' auto Macro ' ' Keyboard Shortcut: Ctrl+j ' ActiveWorkbook.RefreshAll End Sub

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
Back
Top