refresh

Hi all, I have several data files in a standard format (xlsx files, 1 tab (all named the same), 4 columns of data each (all common headers(Owner, Supplier, Amount and Account)) - varying numbers of rows in each. These files are in a folder on sharepoint (no option to save these outside of...

Hi. I am trying to do a Code in excel VBA to refresh SAS tables instead of pivot tables. I have some tables that contain data and are connected to Statistical Analysis System (SAS) and I need to refresh them. I am using this code to refresh everything once but sometimes it doesn’t work: Sub...

Hi, I need to update pivot tables in a certain order, can some help with this? The data is on a tab called Details, on this tab I have a from/to date range and a refresh button The first pivot table is called Helper Pivot The second pivot table is called Pivot, which pulls data from both the...

Hi i am wondering if there is a way to refresh a group of queries using vba one group is called "Source data" or if that is not possible is there a way to refresh specific queries, some are connection only and others are tables example of queries: "filepath_New" "file_Path_Code_Old" thank you!

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

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

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

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: *...

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

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

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

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

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

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

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

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

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

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

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

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