refresh

  1. S

    Refresh pivot table external data with encrypted password

    I have 10 excel files that contain a table with many columns and many rows and that need to be updated frequently with new data. In order to have a faster record of some data from these files, I created a separate excel file that centralizes them all 10 files by external pivot table data and...
  2. W

    Auto Refresh Power BI

    I am using an Excel workbook with several tables to create a Power BI Metric package that publishes to an internal SharePoint site. The employee responsible for updating the Excel workbook is not capable (via access or skill) to refresh the Power BI dataset. How can I automatically get the Power...
  3. J

    VBA: Query refresh always runs first regardless of where it is in the code.

    I'm trying to create a macro that does the following: On theButton was clicked set theButton style =msoShapeStylePreset12 Run the query Query refresh completes set theButton style = msoShapeStylePreset14 end But, the button doesn't change until after the query has refreshed. I eve...
  4. A

    VBA Entry and Verification Form

    VBA Scripting is NOT my strong suit. (VERY BASIC USER HERE) I have a data set of users due for a PC refresh. My manager wants to get our techs to fill in a data sheet indicating when a user has picked up their refresh, but does not want to give all the details from the dataset to the techs...
  5. R

    Send email on workbook refresh

    Hi I think this is a big ask, but here goes! I have an excel sheet which is refreshing and pulling data from a googlesheet. What I am wanting to do is when a refresh occurs any new line will trigger an email. The data coming in will include an email address (Column J) I would also like to...
  6. P

    Repeat Macro

    Hi All, Been looking all over the place and cant find an answer to the following I have this simple macro and want it just to repeat constantly with it never stopping Sub refresh() ' ' refresh Macro ' ' Calculate End Sub So wondered if someone could assist at all please???
  7. M

    Last Modified Date/Time

    Hi, The below works however it does not update automatically, I have to click in to the cell and then refresh the cell. Can any one advise how to automatically refresh this once saved/files opened? Function LastSavedTimeStamp() As Date LastSavedTimeStamp =...
  8. gheyman

    Split form Refresh Problem

    I have a split form based on Table. The below code runs an append query that updates the aforementioned table. My problem is that after the append query is run, the Split form does not refresh to show the new data that was added to the form. If I hit the Refresh button in the Ribbon the form...
  9. 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...
  10. 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...
  11. 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...
  12. 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
  13. 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...
  14. 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...
  15. 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
  16. 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...
  17. 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...
  18. 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)
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top