refresh all

  1. B

    Manual Recalc on Refresh All?

    Hi - is there an option that allows "Refresh All" to recalculate a workbook prior to refreshing pivots & queries? I have a workbook that is using manual refresh. When I click refresh all, I'd like the workbook to be recalculated first (instead of relying on a user to remember to recalculate the...
  2. W

    Power Pivot Table Refresh Issue

    Hi and thanks for having this forum to discuss issues with Excel/VBA. 1) I have created a macro to take raw data and make a Table and several Power Pivot Tables to show "Count of Disputes" and use those values on another sheet and it works great. Disputes(PivotTable14) Location All...
  3. C

    How do I update the screen -without clicking out to refresh?

    I have a code to deactivate a command button on sheet 2 when cell A1 is being used. I have to click on sheet 2 then back to sheet 1 then back to sheet 2 to disable/enable command button (to activate it) Is there a way to update the commandbutton instantly? (execute the program) Private Sub...
  4. J

    Auto Refresh PivotTables & Queries not working

    Hi Excel Gurus, I created a spreadsheet... (tab 1) - Source Data (OLD data) (tab 2) - Source Data (NEW data) (tab 3) - Power query to combine (tab 1+2) Old and new data (tab 4) - I have created a pivot table based on the Power Query (tab 3). Now when I update the data in tab 1 & 2, the Power...
  5. J

    Timestamp for last refresh in pivot table

    Hi Excel Gurus, I have a spreadsheet, two (tabs) are data input manually. I used a power query to format the data. Then I used a pivot table. To refresh the table, I must select "Data > Refresh All" Is there a way to display the last refresh date and/or refreshed by who? for when my pivot...
  6. M

    Refresh All button vs button tied to .RefreshAll method

    I have a VBA project that will crash if I click the Refresh All button found on the DATA tab on the Excel ribbon. However, if I create a button and tie it to ThisWorkbook.RefreshAll, the project works perfectly. Why might this be?
  7. P

    Pivot Table Auto Refresh on a Protect Sheet

    Hello - is there a way to have a protect sheet with a pivot table auto refresh when the source data is no protected? I am trying to export the pivot table (which is on a protected sheet) to a share folder access. The Pivot table is protect so each employee only sees the information they are...
  8. X

    Dashboard Objects are Randomly Resizing on a Data Refresh!

    Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...
  9. U

    Copy Table and Control When it Updates

    I have a table that gets it's data from the web. This table is then linked to a PowerPoint as part of a report (i.e. use the paste special option and link the worksheet object). Once a month, the connection is refreshed, new data retrieved and a new report created. I want to include a 'previous...
  10. C

    Paste Contents from Clipboard to MS Query Parameter

    I have a spreadsheet with multiple queries linked to it. When the user wishes to refresh the queries, they press a "refresh all" button I have provided to them which just saves them the time of having to utilize the built-in menu options simply because they never remember where to find it. The...
  11. 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...
  12. 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...
  13. 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.
  14. 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...
  15. M


    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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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