connection and pivot

Hi, Kind of an awkward one to explain. I have a Power pivot that pulls data from an external table. - This works and refreshes as it should. I then have a number of pivot tables using the multiple tables option (Add this data to the Data Model) When I refresh these, all the pivots with the...

Need some suggestions on how to repair the connection to the data source after updating Power Query. Typically I would pull in data from a folder off a server, however this is my first time making a connection through an Access database. I have pulled in several data sets from an access...

I have three pivot tables in a workbook, and three slicers on one page next to one of the pivot tables. The pivot tables are all linked to the same data source. The three slicers are linked to the same fields in all three pivot tables (Product, Project & Supplier). I need to connect the slicers...

Over the past few months, I have been working with a file using Powerpivot, and until recently the data was populating the table as it should. Recently, a change was made to the data model that redefined some of the fields within the data model. As of today, the link between my main data table...

Hi, i have several excel pivot with excel Sheet1.Range("A1:U900") as data source. Now i have same data in access and want to switch the data source automatically using vba because i do not want to go and manually create all this pivot again. I have created a connection manually and now i am...