refresh

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

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

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

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

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

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

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

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

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

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

Hi, I need help writing a vba code which had 7 textboxes and an update button to update the listbox then spreadsheet updated via the listbox. base on the colunm selected from the listbox, it populates through the textboxes. when selected column from listbox is selected, update is made via the...

Hi, I am beginning in power Query in Excel. I have a general issue is the speed of refresh. I have something very basic code like : Source1 = Excel.CurrentWorkbook(){[Name="tblprofit"]}[Content], #"Filtered Rows1" = Table.SelectRows(Source1, each ([Sales organisation] <> null) and...

I have 10 excel files that contain a table with many columns and many rows and that need to be updated frequently with new data. In order to have a faster record of some data from these files, I created a separate excel file that centralizes them all 10 files by external pivot table data and...

I am using an Excel workbook with several tables to create a Power BI Metric package that publishes to an internal SharePoint site. The employee responsible for updating the Excel workbook is not capable (via access or skill) to refresh the Power BI dataset. How can I automatically get the Power...

I'm trying to create a macro that does the following: On theButton was clicked set theButton style =msoShapeStylePreset12 Run the query Query refresh completes set theButton style = msoShapeStylePreset14 end But, the button doesn't change until after the query has refreshed. I eve...

VBA Scripting is NOT my strong suit. (VERY BASIC USER HERE) I have a data set of users due for a PC refresh. My manager wants to get our techs to fill in a data sheet indicating when a user has picked up their refresh, but does not want to give all the details from the dataset to the techs...

Hi I think this is a big ask, but here goes! I have an excel sheet which is refreshing and pulling data from a googlesheet. What I am wanting to do is when a refresh occurs any new line will trigger an email. The data coming in will include an email address (Column J) I would also like to...

Hi All, Been looking all over the place and cant find an answer to the following I have this simple macro and want it just to repeat constantly with it never stopping Sub refresh() ' ' refresh Macro ' ' Calculate End Sub So wondered if someone could assist at all please???

Hi, The below works however it does not update automatically, I have to click in to the cell and then refresh the cell. Can any one advise how to automatically refresh this once saved/files opened? Function LastSavedTimeStamp() As Date LastSavedTimeStamp =...

I have a split form based on Table. The below code runs an append query that updates the aforementioned table. My problem is that after the append query is run, the Split form does not refresh to show the new data that was added to the form. If I hit the Refresh button in the Ribbon the form...