refresh all

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

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