refresh

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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