1. R

    Macro to refresh workbook, clear sheet, refer to path and import columns

    Hi, In my worksheet, I would like to add a macro which does the following at once: 1) refresh the active workbook, 2) clear the contents of a specific worksheet, 3) import columns data from a closed workbook, 4) refer to the path of the closed workbook based on cell data in the open workbook...
  2. M

    Problem with VBA - function needs to be constantly refreshed for proper values

    Dear all, I have an issue with the code below. Function CountColor(CellsRange As Range, ReferenceCell As Range) As Integer Dim indRefColor As Long Dim Format As Range Dim CountColor2 As Integer Application.Volatile CountColor = 0 indRefColor...
  3. J

    Refresh All and then Message stating Complete

    Hi Again! What is the best way to use the ActiveWorkbook.RefreshAll VBA and then provide a Message Box stating that the RefreshAll is complete? I have had my queries refresh in a particular order, only because I am in need of a message of its completion, there is really no other reason for me...
  4. D

    Auto refresh table in other tab based on a filter

    Hello all, I'd like to know how to have a table be automatically refreshed based on a filter. The thing is that I have 1 tab, where I paste some data (its a table), and then i have in other tab, another table which is populated taking values of specific columns from first mentioned table. And...
  5. J

    Table.Buffer - Queries won't Refresh on other computers

    Howdy! Since I see update speed benefit in it, I typically use Table.Buffer in all of my queries by wrapping the very last line. Example Source = #"My Data" in Table.Buffer(Source) as table However, when someone else uses the same template file on their machines, the queries won't refresh...
  6. A

    VBA Code to Copy table contents as values to another sheet works only when have a Breakpoint

    I have some code that copies the contents of a table on one sheet and pastes the values into another sheet. This is part of a longer process that opens an external workbook, copies its contents into a tab in the main workbook, the updates a table via refreshing a query. This part all works...
  7. A

    Refresh pivot table when source data changes

    So I'm running into an issue with some VBA code which states that if the source data changes, refresh the pivot table. If you look at image1 source, the pivot table in "Sheet 7" refresh fine if I manually change the week in A2. Which is great, the code is running in the "Calculation" sheet and...
  8. X

    HELP - Dashboard Objects are Randomly Resizing on a Data Refresh!

    Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...
  9. mdbrierley

    New columns added to end of table

    Hi, I created a tracker for 2022 that has targets along side "actuals". So I've been testing this by adding in data and refreshing and it's giving me some issues. Namely that even though it looks fine in the editor, when the table is refreshed in excel, any new month actuals get put at the...
  10. E

    Some Cells After MS Query Table Refreshed Have to Be Clicked before Formatting Works

    Hello all. I have a situation that is driving me crazy. First off, I am using excel in Office 365. I have a workbook in which I export data out of SAS tables into different sheets. I have a main sheet where I use MS Queries to pull that data in from the other worksheets in the workbook. I...
  11. wsnyder

    Power Query Background Refresh False Error

    Hi all, Using Excel 365. Is my the background refresh false tripping over another background refresh? I'm getting There are 4 worksheets each with 1 Table created from Power Query Close & Load With wb For Each ws In .Worksheets For Each lo In ws.ListObjects...
  12. wsnyder

    Worksheet Change Refresh Connection

    Hi all, Using Excel 2016. I created a connection only in Power Query to table on my worksheet with a single row to be used as a file parameter. The parameter can be 1 of 2 values based on selection by user and that part is working as expected. I added a bit of code to the Worksheet Change...
  13. V

    How can I run a macro after a data source refresh is completed?

    Tried looking around online, but I haven't come across anything that seems to do what I am trying to achieve. I would like for a macro to be run/called after a data connection has been refreshed whether it is automatic or manually done. I am also looking for the connection to refresh upon...
  14. J

    VBA to wait untill first refresh finishes then continue the second refresh

    Hi guys, I have a report that needs to be refreshed twice before I can work on other stuff. So what I usually do is go to Data - > Refresh All Then once the first refresh is completed, I press Ctrl+Alt+F5 to refresh for the second time. Its refreshing multiple power queries with multiple...
  15. S

    Pivot auto-update w/o "blank"

    I have a Timesheet data table of 100 rows in a worksheet linked to a pivot table on another sheet. When the user completes the timesheet and refreshes the pivot "blank" appears and so there are no totals. The amount of data entered will be different each week. How can I set the pivot to refresh...
  16. carpetony

    Query Connection Property - Refresh every 'n' minutes.

    I run an SPC chart with a power query created table that tests results against Nelson Rules. The samples runs fairly quickly, so I have the Refresh every set to 2 minutes during the day. The refresh triggers a Worksheet_Change event that checks the timestamp of the most recent run, to the...
  17. A

    VBA Error?

    Hi, I have the following VBA code: Set Wbk1 = ActiveWorkbook Fname = "Path name" Set Wbk2 = Workbooks.Open(Fname) Wbk2.RefreshAll DoEvents Wbk2.Sheets(1).Copy , Wbk1.Sheets(Wbk1.Sheets.Count) Wbk2.Close False So basically this code is part of a macro that opens ANOTHER...
  18. B

    Refresh All & Pivot Tables

    Hi. I have a spreadsheet with probably three dozen pivot tables spread across multiple sheets. I am sure there is a more efficient way of doing it. I've never gotten around to learning PowerPivot or macros or whatever else I would need to use, so I use what I know. This spreadsheet gets updated...
  19. M

    Query refresh date / time : how to retrieve in VBA ?

    Hi All, Is there a way to retrieve in VBA the latest refresh date / time of a query ? Thanks!
  20. B

    How do I get a userform to refresh information that changed in the spreadsheet when it is reactivated by

    Greetings everyone... Longtime viewer but 1st time poster. Hopefully this will make sense... I have a userform that tracks who gets a project revision when the person the project belongs to is gone (this part works great). In this userform there is another userform that allows me to alter the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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