refresh all

  1. O

    Excel to record all changes on refresh

    I am NOT the greatest in Excel or VBA. In fact until the last week, I never used VBA, but am learning a lot from Forums and instructional videos. I appreciate everyone of you who participate in these forums and help out those of us who, at times, are utterly and completely lost! I need to...
  2. 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...
  3. J

    Power Query Selected on Refresh All

    When I click refresh all or call it from a macro my power queries refresh as expected, but then they are selected. Which is problematic when the sheet containing the query is hidden... So I added code to select another cell after the refresh all, but what seemed to happen was this: -refresh...
  4. D

    1 master workbook with multiple separated workbooks on pivot tables and charts

    Hi Excel Experts, I have this 1 workbook containing multiple macros, a master data worksheet and multiple pivot tables & charts in separate worksheets. I thought it would be easier to refresh all pivot tables and charts whenever there is a change in the master data. However, since the pivot...
  5. N

    which pivot table is not refreshing

    I have an excel workbook with lots and lots of sheets. Each sheet feeds into at least two pivot tables, so I have 100 + pivot tables in the workbook. When I hit "refresh all" to update all the pivot tables, I’ve getting an error message “One or more field names used in the report are no longer...
  6. Y

    Refreshing Query with UserForm

    Hi, I have a UserForm with text boxes. When data is typed into a textbox, it is inserted into a cell on "Cost Analysis Tab" with this code: Private Sub TextBox4_AfterUpdate() Worksheets("Cost Analysis").Range("A1").Value = UCase(TextBox4.Value) End Sub I have a Connection Name: "Query from...
  7. M

    Refresh all pivottables when deactive data sheet

    Hi I have this deactive macro for Sheet1 (data sheet)(create by right-click on sheet name and insert module): Private Sub Worksheet_Deactivate() Run "PivotMacro" End Sub and this is Pivotmacro : Sub PivotMacro() Dim pt As PivotTable For Each ws In ActiveWorkbook.Worksheets For Each...
  8. R

    Refreshall Twice

    HI , I have 5 pivot tables , 3 are connected on 1st raw data and other 2 are connected on 2nd raw data and I am trying to refresh them using both Excel refreshall button or Alt+f5 and I even tried macros(activeworkbook.refreshall) but It's not working for the first try , All I need to do is to...
  9. C

    VBA Code refresh- unhide - unfilter - ungroup

    Hi All I am desperately looking for a Macro that would allow me with the click of a button to go through all the sheets of my workbook and do the following to every sheet: - ungroup columns and row - unfilter - refresh - re filter - re group from the first sheet after the sheet that contains...
  10. O

    power pivot wont refresh

    hello everyone, i have a huge problem and i hope you can help. i'm using excel 2013 and i bulit a very big excel that has about 20 pivot tables. when i built them i used the "add this data to Data Model" option and now i send this file to a client for him to use. the client is using excel...
  11. P

    how to bypass file selection when refreshing data imported from a text file?

    Hello, I am wondering if it possible to bypass the pop-up window prompting to select the text file when refreshing data imported from text file. I have a tab separated text file that gets updated by an external program. I find it annoying that I need to select the file every time I want to...
  12. A

    Data Tab "Refresh/All" Button Triggering Macro

    I have what I would think would be a very easy question, but nothing I've found has answered it for me. I apologize if this has been answered (please respond with the link to the answer if it has) but I can't find anything. What I need to do is this: when an end user clicks the "Refresh" or...
  13. N

    Need help with making live connection. IMPORTANT!!!

    I have a master table that contains 955 rows with 10 Columns (Case No., Invoice No., Date of Charge, Category, App. Type, Country, Attorney, Foreign Firm, Cost, Year). There are 9 categories and 14 countries. I want to make a new table that is connected to this master table but is ONLY made up...
  14. H

    Excel 32bit crashes on refresh macro on a 64bit pc

    I have a spreadsheet with drop down criteria that queries a database. A 'command button' prompts the user to 'refresh' the data. The macro is very simple. ' ActiveWorkbook.RefreshAll ' When 'clicked' on a 64 bit pc - Excel crashes. The only way out is to 'End Process' via Task Manager. If I...
  15. K

    Refresh Multiple Pivots but only type username and password once?

    Hi, I have a spreadsheet which has multiple pivots. The pivots pull in data from an external data source/database. The issue I have is when I hit the refresh all button, I'm prompted for the same username and password for each pivot. In all there is something like 35 pivots so that's 35 times I...
  16. P

    Excel VBA Refresh Wait

    I am trying to create a button with a macro code. When the button is pressed it will run a refresh code for a webpage. One of the sheets is updated with the information from this website. There is a waiting period for the refreshing. When done refreshing the rest of the code is run. My problem...
  17. C

    Power Pivot Macros to Refresh All Data

    Hey I'm looking to create a button for the user with a macro assigned to it to refresh all the data in the Pivots. However Im using power pivot for the data. If i record a macro and refresh power pivot it doesnt seem to record anything which happens in the power pivot window. I'm looking to...
  18. C

    Microsoft Query - refreshing all

    Hoping someone can help. Issue: On a frequent basis a report is run and exported into an Excel format on to the server. The file is always named the same thing, let’s says Hours.xls, and overwrites the existing file to always have the most current data. We need to view the Hours data in a...
  19. N

    Refresh All for Pivots

    Hello, This might seems like a simple question but if I hit refresh all from the ribbon in excel, will it refresh everything single pivot in the entire workbook or just for that sheet? Thanks!
  20. J

    Refresh Multiple Workbooks (Excel 2003)

    Hi! Just a quick one..... that's how they all start right?? I wanted to know if there's a way to update all the queries in a group of workbooks without going into each one individually. I'm guessing the solution is VBA related but can I do it without opening Excel? The data comes from an...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top