refresh

  1. L

    Power Query - Dynamic Column Headers - By Date

    I import a file each day that contains about 40 columns of data. 15 of the 40 column headers are dates for the next 15 days from the current date. Therefore, each day the column headers change in the source data for those 15 columns. My refresh will crash each day since it cannot find the exact...
  2. A

    Refresh Morningstar Data at Specific Time

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

    Class Not Registered Error?

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

    #GETTING DATA, DAX issue

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

    Access Database Form Wont' Allow me to Update Records

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

    VBScript code to wait for Refresh All before saving excel file

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

    how to stop auto show query table at refreshing

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

    Refresh just one DAX measure based on a cell change

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

    Excel VBA to refresh just 1 DAX table

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

    block user from refreshing pivit tabel

    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)
  11. O

    Edit Queries grayed out - How can I view the source data in Excel and append data to this source?

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

    Browser Page Refresh: Reflect new data after scheduled refresh

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

    Keep Pivot filers when updating source data

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

    Auto refresh Pivots with Group Data without VBA

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

    How to Refresh Data -Automatic on daily basis - 2013

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

    Speeding up 900 Simultaneous Web Queries

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

    Query Refresh - Why does it duplicate

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

    Set excel file to automatically refresh the same time each day

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

    Excel 2016 error

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

    PivotTable refresh date history / flag new data since last refresh

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

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