Hello
I am having a problem in connect a pivottable from another pivottable (both pivottables are from the same source data).
Steps I have taken:
On the Data tab, in the Get External Data group, I clicked Existing Connections.
In the Existing Connections dialog box, in the show box, I make sure that All Connections is selected.
I do not have any connection yet so I clicked on Browse for More
In the Select Data Source dialog box, I clicked New Source to start the Data Connection Wizard so that I can select the data source that I want to connect to. I select ODBC DSN
In the Data Connection Wizard and clicked next
On the ODBC data sources, I select Excel Files and clicked next
On the Select Workbook dialog box, I navigate to My file and clicked OK
My problem starts here:
8. On the Data Connection Wizard the file I navigated is listed on the text box on Select the database that contains the data you want but the next button is grayed out. when I unchecked the Connect to a specific table, the next button becomes available. I then clicked next
9 . On the Save Data Connection File and Finish dialog box I Clicked finished. This then give me a Microsoft Excel dialog box that states This data source contain No visible table.
Note:
I created the Pivottable from the same data source contained in the Worksheet named Orders from the table called Orders. I named the two pivottable: Pivot1 and Pivot2
What is the way forward:
If correct, I should be presented with the Import Data dialog box, where I can select how I want to view this data in my workbook and then insert a slicer and then do my ultimate objective to connect this slicer with the other Pivottable
I am connecting Pivot2 to Pivot1
Thanks for your help in advance.
Bookmarks