I'm trying to use the "external data source" option in creating a pivot table in order to combine related table information from different tables into a pivot. However, when I choose the .xlsx file I want to use I get a message that says "OBDC Excel Driver Login Failed ... External table is not in the expected format." I can choose an older excel file (.xls), but it isn't letting me choose a new version (.xlsx); and I need to because the data source has too many rows for the older version.
I tried also accessing the file directly in the Microsoft Query and again received the same message as above. The file has five tabs/tables that I would like to create a pivot from using defined relationships (I'd prefer to stay out of Access as I'm not as versed there).
How can I use .xlsx files in this way or is there another option for combining excel tables in a pivot where I use table relationships (i.e. Query).
I appreciate your help on this.
I tried also accessing the file directly in the Microsoft Query and again received the same message as above. The file has five tabs/tables that I would like to create a pivot from using defined relationships (I'd prefer to stay out of Access as I'm not as versed there).
How can I use .xlsx files in this way or is there another option for combining excel tables in a pivot where I use table relationships (i.e. Query).
I appreciate your help on this.