refresh

  1. F

    Using Excel while queries are refreshing

    This may be a silly question, but does anyone know what the effect will be if I'm actively using other instances of Excel while the queries in another workbook are refreshing? I've been working on linking a spreadsheet to a PowerPoint library. It pulls data from dozens (eventually hundreds) of...
  2. M

    Excel online - how to trigger its powerquery/output table to 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
  3. C

    Pivot table issues

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

    Pivot Table - Multiple Column Headers Merging After Filtering

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

    Query Refresh in VBA - is taking so long that the copy/paste after it copies old data

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

    VBA Power Query Load to table refresh redundant code?

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

    Remove data on worksheet without deleting query

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

    Macro To Refreash A Sheet Every 15 Min.

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

    Display live(ish) excel data in webpage

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

    Excel Refresh Connection to Access very slow

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

    Disable Refresh in Power Query workbook to create backup?

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

    Access: Refresh All

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

    Macro after Web refresh

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

    How to access external add in to click some buttons

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

    Refreshing Blank Query - Duplicates

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

    ActiveSheet Refresh

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

    Auto click refresh all icon when table values change

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

    Refresh button on Analyse Tab

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

    How to get a listbox to display the first row

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

    linked image not refreshing

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

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top