refresh button

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

I have Power BI file that has 12 data tables: 7 are only refreshed once a month but the other 5 need daily. Is there a way to create a button for just those 5 to refresh? I have been having to either refresh everything or each report individually. Due to the amount of data, doing everything...

Hi, I have a macro setup that captures all of the sheet names in a workbook, and puts it on a Contents page (sheet 1). It's working great however it doesn't automatically refresh when a user changes sheet names. I have to ask users to manually press Ctrl+ Alt + F9 each time they open the...

The end goal is to have an Excel Table with a refreshable data connection to a web table. The reason to have an Excel Table is to use that Table as a reference point on other sheets, to perform calculations on other sheets, and to create summaries on other sheets. All of this is made much...

Hi fellow Excel geeks. I recently switched to Excel 2016, so I'm not sure how to handle a VBA issue. I'm making a report for our low-level managers, many of whom don't have great computer skills, so I want to make it as easy as possible. They copy data exported from our database into a tab. The...

hi, please read the full thread to know what i want to see in result: this is second post to MR.EXCEL as in first post i didn't get any reply except one from "hike" which i really appreciate Now , i am creating an excel file file which has two sheets Sheet 1 and sheet 2 in sheet 1 their...