refresh

I am working to refresh morningstar data in an excel 2016 file, and I found the following code online on the Morningstar VBA guide: Public dTime As Date Dim lNum As Long Sub RunOnTime() dTime = Sheet1.Cells(1, 1) 'change the cell reference here (Row #, Column #) Application.OnTime dTime...

Hi, I have an Excel Workbook that is using Power Query to take 3 excel files and append them into one report. I have a VBA code that opens those 3 excel files which are connected to a SharePoint site and refreshes them to capture any modifications made to any of the entries. The issue is, the...

Hi, all of a sudden 4 of my tables wont update. They say "#GETTING DATA". Only if i go into dax and manually refresh will they update. Or if I select the QRY inside excel and refresh the workbook connection. I've tried removing and readding it back to DAX. But still have the same issue? Thanks

I'm ultimately trying to setup an access database form, that has current data in it from an imported excel file that can allow updates. I have the form built but when I try to type in the fields it says "This Record set is not updateable". I do keep trying to setup the primary key but it won't...

I have put together a VB script to refresh all excel files in a folder without opening them. The issue I am facing is that the excel files close before allowing the data to be refreshed. Is there any way to force the VB Script to wait till the data is refreshing and then save the file? Also, I...

hi​ I'm trying to get a few columns hidden with my worksheet using Power Query. I've tried hiding the columns like you would do normally in Excel, but every time I refresh the query the columns automatically unhide. What can I do to prevent the Columns from unhiding. Thanks

Hello all, I'm looking for a way to refresh a DAX measure not the whole workbook. When I change a value in a cell. So if I change let's say the date in a cell I want a specific measure to be updated. Otherwise refreshing the whole workbook takes may staff 20 minutes. When I can go direct to...

Hi, I have a workbook with many pivot tables. I would like a VBA macro to run when the PIVOT TABLE changes. I have a dax table that is based on a excel table. When I change the value in the Excel table I would like to refresh just the one DAX table. So that my pivot table is updated. If I...

hi is there a way through an excel vba to disable the refresh button in excel for a power pivot table or any type of refresh ? i don't want to protect the sheet i just want to disable refreshing it (with a password)

I still have access to an intern's account who no longer works here. He created a report in "Service" under his "personal workspace" so there isn't an option to download the *.pbix file. So I ended up going to "Desktop" and I was able to select the same dataset he used in "Service" and I...

Hi, Does any one knows if there is a way to refresh the Chrome view of a power bi report in the service after the schedule refresh? (without using Chrome add ins) [ i have a report that is presented constantly on a tv and refreshes once a hour or so, the view does not update after the...

Hello, Self taught daily user that occasionally dreams that I have to VLOOKUP people before I can speak to them.. :eeek: I have many pivots per tab. I deleted the source data and replaced it with new data and refreshed all. Some of the filters did not keep, and some did. How do I lock down...

Hi all, not sure if this is possible, but... Does anyone know if you can update a Pivot Table that has grouped date data (Year and Quarter) automatically, but retain that grouped date data after the refresh? I have been able to get the Pivots to update when I save and re-open the sheet (using...

Good Morning , We are using Office 2013. We connected to Oracle DB , make query and make Power Pivot query -> All working ok Now whenever we need to get the updated data - we are doing manually -Data -> Refresh All. But we need to have 'Refresh Automatically' - For example say by 10 AM...

Hello: I currently have a spreadsheet that is pulling pricing information from the Internet in 900 queries. Currently, each query returns a 4 x 7 table of data assigned to a unique worksheet. The problem is that it is taking 1 hour, 20 minutes to update. So far, I have disabled the...

Hi, I have - Query1 = Excel.CurrentWorkbook() Below pic shows query properties. How do I refresh this so that only new rows are added. If I manually refresh, the 15,970 rows duplicates giving me 32,000 + rows. I only want the 15,970 rows plus the new rows...

Hi all, I'm hoping that someone can assist me with this! I have an Excel file located on my C drive C:\Users\Barry\Concessions\Concessionsregister.xlsm There is an access database in the same location C:\Users\Barry\Concessions\ConcessionsDatabase.V1.accdb I have a data connection in excel...

Hello all, I have issue where one of our Excel spreadsheets suddenly shows following error message. External Data Refresh Failed This Command requires at least two rows of source data. You cannot use the command on selection in only one row. We were unable to refresh one or more data...

Hi I'm trying to flag data that appears since the last time the report was refreshed. For example, if the sale date was 28/07/19, flag this row as "new since last refresh", if the record wasn't present on the last report version. Any ideas please, guys? I've Googled about and looked through...

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