refresh

  1. T

    Excel Native Query Unlink/Refresh problem (BUG MAYBEÉ)

    Hi, I have a problem with the NATIVE Excel Query as follows: I have a master file that contains 5 queries loading data from 5 tables on 5 different files on a SharePoint site. I also have a MASTER QUERY that combines these 5 queries into one Master Query. All work fine when it is all...
  2. K

    VBA Help

    Can anyone help with the below code. I keep getting an error of "This will cancel a pending data refresh. Continue?" even though all the tables have updated and then when the save happens I am getting a box to ask if I want to save changes. I thought what I had below would just save the...
  3. K

    code not working - HELP !!

    Sub removeFilters() ActiveWorkbook.RefreshAll x = 1 ThisWorkbook.Sheets("Tracking Log").Unprotect Password:="test" For x = 1 To 19 ThisWorkbook.Sheets("Tracking Log").Range("B14:T14").AutoFilter field:=x, visibledropdown:=False Next x ThisWorkbook.Sheets("Tracking...
  4. M

    Refreshing External Connections In Power Query

    I set up external connections to excel workbooks to load data into power query (went fine). I decide to test the refresh feature by changing some things in the source data. It won't refresh -ever. Any idea what he problem is. What's the point of having a refresh feature if the connection...
  5. M

    excel crashes upon refresh of an exteranl data source

    Hello, I have been using 5 workbooks for about 3 years they al pull data from a master file. Now when I t to refresh connections it immediately crashes. The message says "Microsoft excel has stopped working" Any help would be appreciated.
  6. B

    Pivot Table Retained Items & Refresh All

    I have a spreadsheet that updates based on a user-entered date range. I'm running into two problems. 1. There are some values I need to exclude from the pivot tables. For example, the number of rows of data will change depending on the date range. I have index match formulas where I set the...
  7. A

    Cannot open PivotTable source file

    Hi, I just got a new laptop at work and I am getting an error when refreshing pivot tables. I have had pivot tables that refresh from data in a closed workbook for the last 3 years. Now on my new laptop when I try to refresh the table I get an error saying "Cannot open PivotTable source file"...
  8. H

    Excel VBA Query Refresh Very Slow

    Below, I have an Excel VBA statement that takes 20 MINUTES to complete: Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False Versus, when I right-click the query table in the sheet and manually hit "Refresh" - it only takes 10 SECONDS to complete! What's the deal? Is the VBA...
  9. HomeTek

    Refreshing Data Based On A Pivot Table

    Hi all, So I have a pivot table and I know if a change is made to the source data I can simply refresh the pivot table to update it. However, is there a way to refresh the new sheet that is created when you double click on the total within the pivot table for example? Pressing refresh on the...
  10. P

    Copy data from IE using VBA

    Hi All, I have a VBA code which will open a website. Now i want an information to be copied from the website to the excel sheet. In the website at the top right corner there will be a text with name "Last Refresh" followed by that it will have date and time. I want this to be pasted in the...
  11. T

    Infinite OLAP Refresh Loop

    Good Afternoon, I have an excel workbook in which there is a pivot that is connected to power BI. When I attempt to refresh this pivot I get stuck in an infinite refresh loop forever. It just says the following things over and over again: Running OLAP query Refreshing the OLAP cube Waiting...
  12. leopardhawk

    Question about data refresh

    I have four worksheets in my workbook that I wish to hide. All four are running data refresh via web queries when the file is opened and I am wondering if they will still be able to do that if the sheets are hidden? Unfortunately, I can’t test it because the updates are year-end and I would like...
  13. W

    Does scheduled refresh works properly for someone?

    Hi guys, I am really struggling to use PowerBI in the following setup: I have a PowerBI desktop. I Created a project where I import data from an excel file on my PC and I installed personal gateway and setup a scheduled refresh, so it will be published online also. I get to endless problems...
  14. Z

    Power Query connection to files on SharePoint - users cannot connect

    Hello, I am using Office 2016 and Windows10. I have 4 files all in a SP doc library - 1 main file with connections to 3 Excel files in the same library. I originally set up the connection using Data > New Query > From File > From (Excel) Workbook. Users had permission errors, I did some...
  15. S

    Power Pivot not refreshing on opening. Excel 2016

    I have set up three reports to generate overnight and create 3 .csv filesI have created a spreadsheet where these csv files are read by the data model and from there, create power pivot tables.The requirement is that the pivot tables read the most current data whenever they are opened - they are...
  16. B

    Clearing Excel AutoFilter using VBA

    I am using this VBA code to refresh my entire workbook at specific time intervals. As you can see, it is currently set to refresh every 60 minutes. Public RunWhen As Double Public Const cRunIntervalMinutes = 60 Public Const cRunWhat = "Workbook_RefreshAll" Sub StartTimer() RunWhen = Now...
  17. R

    Pivottable doesn't contain all the data auto of query

    Hi all, I made an Excelfile (xlsm) with several connections to a part of a database and set some filters in query. With the filtered query data I made some pivot tables. While validating the file I found out that some data which are available in query, aren't available in the pivot table. When...
  18. P

    Macro Running on each refresh

    HI. I have created a tracking sheet which takes data from another excel sheet by refreshing links every 30 seconds (would use share workbook but function not enabled by my work). I have created a macro to play every time a cell in a range is changed to a value above 0 but it reads every refresh...
  19. S

    Connection Properties - Refresh on Open greyed out.

    Wanting data source to refesh on opening Workbook however most of the options are greyed out. In particular "Refresh data when opening the file" Any advice appreciated.
  20. M

    Refresh query/powerquery of my Excel Online file

    I have an Excel data table and a separate Powerquery that result in an output table. Of course I can manually set refresh every 1 minute for the query and do the same to refresh the output table while I am in desktop Excel. But now the file is uploaded to Office 365 Business. Please anyone can...

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