refreshed

Hi, I have code that automatically does a RefreshAll when a worksheet is activated. My issue though is that I need the refreshes to happen in a certain order since pivotables are based off of connection refreshes. I would need all connections to be refreshed first and then all pivotables to be...

So I have a table in which i'm trying to add a check to see if any values in the last column of this table return a value of "FALSE" (it's worth mentioning that this "FALSE" is not strictly text - it's an IF formula result) . I'm using the CountIf formula but I can't seem to get it to work...

I have two sets of data which contain some (43) columns in common. I would like to refresh the shared columns in dataset 1 with dataset 2 (as dataset 2 will be updated daily) I'd like to be able to do this by clicking a 'refresh' button in dataset 1 which then has it's data refreshed by using...

Hello, i have a workbook, that i want to share, currently it has two tables within it. The tables are refreshed through VBA from a sharepoint connection. I am aware how to convert the Tables to Ranges which will allow me to Share, but this removes the connection I have. Is there away of...

Good afternoon All, I was wondering if someone could assist me with a VBA code which I can embed on to a sheet so that whenever that sheet is opened a power query table that is part of that workbook is refreshed. Not sure if this is enough detail. If not, please let me know Many Thanks Herbz

Hi, i have a pivot table with: 1 field in Rows + 4 fields in values when my data is cleared and pivot refreshed, i lose 2 of the 4 value fields. How can i make sure these never aren't removed? Appreciate any help edit: if it helps the 2 fields that are removed are both SUM of values

Hi, all. I've created some pivot charts with slicers in Excel 2013 for Windows. When my user opened this file in his Excel 2016 (Pre-Release Build from Office Insiders) for Mac,the chart still good. But when he refreshed the data, pivot charts layout becomes messy. Before...

All, Below VBA code I am using to refresh Oracle BI report data in Excel. It is connected to Oracle BI using Smart View. I am able to refresh data using below code. It shows a message once data gets refreshed such as 'Table1 is refreshed', Is there a way to suppress this message...

I have set up a data model with the main source of data being a bunch of CSV files in a particular folder. Data is grouped by month via the pivot field which works fine. The only issue is that I need to order the months July-June and every time the data is refreshed they divert back. When I...