change data source

Hello everyone, I have a scenario where, every day, I have to manually set the Data Source credentials to Windows Authentication in order for my queries to refresh. I currently have a few queries that connect to two different excel databases (one on SharePoint, and the other on our company's...

I have a file containing approximatly 150 pivot tables, all sourced to another work book. Is there a way in which I can change the data source for all of these pivot tables in one go? The data source is a different workbook that the one the pivot tables are in.

Hi Excel experts, I have a question regarding if this can be done or not and also I you have any better idéers how to do this. We have an viriualization environment and we are collecting information and trying to view an resource picture to all departments that are using the environment. We...

Hi guys, I have about 8 worksheets in a workbook, all of which have pivot tables that link to the same data set. I want a piece of code that changes the data source of each pivot. Here is the code i am using Sub RefreshPivotTables() Dim ws As Worksheet Dim PT As PivotTable Dim SourceName As...

Hi. I have 6 tabs with pivot tables. They are all attached to the same external excel file. Each day I need to reassign the pivot source to a new file. ie 080112 file.xls to 080212 file.xls. I don't want to have to change data source for each pivot one at a time. Can I make the change...