refresh all

  1. C

    VBA to create an error message when any Power Pivot connection fails on refresh

    Hi, I have a workbook that is connected to my BI database through Power Pivot. I have some VBA which refreshes all the connections & creates the workbook. I would like some VBA that brings up an error message if one of the connections fails to refresh - similar to if I was to refresh through...
  2. S

    Pulling list of Unique Names from Refresh-able Table between Date Range (Or Month Number)

    Hello! Thanks for any help in advance: I'm attempting to create a "dynamic invoice" of sorts, with names being pulled from a "refresh-able" table. By that term, I mean an excel table that (I'm assuming) is pulling from an SQL query and just needs the "refresh all" button on the Data tab to be...
  3. A

    RefreshAll in Excel sheet which connects to SQL

    Hello guys, I Need to do Refresh All in Excel Sheet which connects to SQL. I tried Record Macro but i am not getting any code. Can anybody help on this please. In Excel Ribbon - Data Tab - Refresh All.
  4. S

    Excel Built-In Exchange Rate

    Hi, I recently watched the MrExcel YouTube Video about the built-in exchange rate function in Excel (link below). It's very useful but currently has a drawback that to refresh the rates the only way possible seems to be Refresh All which really slows Excel down, is there a way to just refresh...
  5. M

    Refresh

    I have an Excel Spreadsheet with a data model with several tables in it that are linked together in the data model. Then I have created a Pivot Table in Excel based on the measures and tables in the data model. My simple question is, if I go to the Data Ribbon and hit Refresh All, is it...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

Top