1. iosiflupis

    Issue with refreshing Power BI online

    I have Power BI online thru our city. I have a data set that I was working with using Power BI Desktop. When I am using the online app, I tried to refresh the data. I am getting this error: Data source error: Scheduled refresh is disabled because at least one data source is missing...
  2. R

    Letter Log Reminder MsgBox not updating

    Hi! new issue came up, previous issue is resolved. However, the Msgbox only display the current data in the cell. if new data is entered in the worksheet, it will still show the previous msg. like for example as shown below. The msgbox will show that reminds your that the letter number 00001...
  3. S

    Show Items With No Data Not Working the Same Since Nov 2022?

    I have a spreadsheet that I haven't refreshed since the middle of November 2022. When I refresh the data today, the chart shows every month instead of only the filtered month! Has something changed in excel since November 2022? This used to work, but now doesn't, and all I did was RMB...
  4. A

    the ultimate refresh-all script?

    Hi all, Looking for this for a long time, but never found a definite and all-round 'one-button' vba script. Maybe someone can pull this off and make a lot of people happy with this; unfortunately I'm unable to pull it of myself. So the question: I want 1 script that, for the active workbook: *...
  5. M

    Can't find and delete unwanted external link

    Hi guys, My file pops up an error msg every time I refresh it says can't find the external file used, but actually, I don't have any formula or table linking to that file -- I have checked: 1. and 2. None of these involves the file the error msg mentioned. I do find the file in Existing...
  6. J

    Query error when I refresh manually and in VBA?? Frustrating!!

    Hi All, Got another issue but this time pertaining to an Expression Error which I cant quite figure out. The workbook that I'm working on is connected to Dynamics 365 where a separate tab showing all the data has been created. I have built the data entry and and pivots around the fields that...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. X

    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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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