refresh

I have an Excel file having a Table (data) and a powerquery that result in another table called Output. This file has been uploaded to Onedrive Business. I need to refresh this output table/powerquery ... what is the tools or way I can use to refresh it ? Thanks

Hi, I have created a template for providing monthly reports on financial figures. I paste 1x row per project in sheet(1), then I have 7x sheets with the exact information (they are all linked). To those 7x sheets I have 7 different pivot tables. When I update sheet(1) with new information and...

Hi everyone, I am having issues with a pivot table merging 2 column headers and count of values together when I filter out Blanks. I've created an example workbook of the source data, what I'm doing (which is definitely wrong), and an example of what I want it to look like...

Building a macro that will refresh a query (with existing extension), take the results (anywhere from 50,000-100,000 lines), and copy to a different spreadsheet. The macro works, but the query refresh takes so long that the macro moves on without waiting for it to finish. Is there a way to...

Hi All, I've used the macro recorder to record the loading of a power query to table and I'm curious if the last line of code is redundant? With Sheets("Temp").ListObjects.Add(SourceType:=0, Source:= _ "OLEDB;Provider=Microsoft.Mashup.OleDb.1;Data...

My worksheet contains query which I can easily refresh by right-clicking and choosing refresh. However, I want to remove the values on the worksheet without removing the query. If I did that manually, a message pops up asking if I want to remove the query as well, so that if I choose no, the...

I have an Excel sheet running on a big screen and would like to refresh the sheet every 1 min or so. The code below I can refresh manually but can I run a second macro or add to this on and refresh and save automatically? Thanks Sub Update() ' ActiveWorkbook.UpdateLink...

Hi I have created some reports in excel and have various pivots and graphs that I can view/refresh. What I would ultimately like to do is have the contents of the excel page displayed via a web browser so this can be seen by people across the business with out them using the excel spreadsheet...

Hi, I have a table in Excel that links to a table in Access which is taking a very long time (>45mins) to refresh. Table size: 252 fields/columns, 11,000+ rows/records of various data types in a single table. There are no additional calculated fields in the table. Pivots/PivotCache using the...

Hello and thank you in advance if you can help, I have put together a Power Query workbook with Pivot tables. All my data is through links, so I will, hopefully, then be able to have everything refresh to provide the new output as I get new data on a monthly basis. I would like to know if I...

Whats the code for Refresh all. If I use the macros its only a Refresh option. Thanks

I have a spreadsheet that imports a web page that I extract data from. Being its a daily refresh the page has older yet duplicate information farther down the page that also imports. I am trying to run a macro that will search for the previous day on the page (=today()-1) in Wed, Apr 10, 2019...

Hi, I have a Facebook Ads Manager for Excel (FAME). I need data daily in my Excel how can I automate to Click Refresh button daily and store values some other location into CSV file or directly into AWS S3. I have been struggling from some time to control that refresh button. Any kind of...

Hi, I have combined all tables in an excel files using the blank query -> =Excel.CurrentWorkbook() If I click the refresh icon it will duplicate all the loaded rows. How do i avoid this & only load newly added rows? https://www.dropbox.com/s/h5rlmhbjac4xetk/refresh.png?dl=0

Hi, I think this is a simple question but I can't figure it out. I'm using this code to refresh a pivot if data on a worksheet is changed but it's refreshing all pivots rather than just the pivots on the active worksheet. Where I'm running into issues is that I dont want to have to specify the...

Hi , Hope you are all good.. Urgent help.. I have created a access database. It has 6 table. have not created ant forms and quires. Users update data manually because it is shared database. like shared excel Requirement is , If any one change any value or update any value in any table...

Hello to all. I've been studying Excel for about a week so please keep that in mind! :eeek: I understand the "Refresh" button is for updating the Pivot Table Cache when the Source Data has changed. Someone told me that is will also update the changes made by others on a Co-Authored...

I'm binding a runtime query to a listbox. I hit the cancel button and the listbox displays the last several rows in the recordset rather than display the first row. ListIndex and the properties I use in Excel cannot be assigned values in Access. How can I get the listbox to display the first...

I have a named range on sheet1 that I "copied as picture" into another sheet. I then click on the image and put the name of the range in the formula bar so the image will update as changes occur on sheet 1. I do this a lot and I know it's pretty common but I'm finding that, on certain...

I'm creating a dashboard in Excel that watches an different excel spreadsheet we use for data entry. It's important that i avoid locking the spreadsheet out, I first tried using the workbook connections however it locks the spreadsheet so it cant be edited it is even set up a shared one drive...