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

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

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

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

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

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?

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

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

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

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

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

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

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.

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

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

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

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

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

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

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