Forum Discussion

Copper Contributor

Mar 16, 2020

Pivot-Tabelle mit Externer (lokaler) Datenquelle verbinden

Eckdaten: Excel für Mac 16.16.10 OS: 10.15.3 Catalina Ich möchte für meine PivotTables eine externe Datenquelle (lokale .csv-Datei) auswählen. (siehe Bild-1) Beim Klick auf "Verbindung auswähle...

excel

Excel on Mac

Riny_van_Eekelen

Platinum Contributor

Mar 16, 2020

andreasbehr

Perhaps here:

https://support.office.com/en-us/article/Use-an-external-data-source-for-a-PivotTable-in-Excel-for-Mac-8e1d8dd2-f8cb-4545-8a56-5651b29173f2

and here,

https://support.office.com/en-us/article/odbc-drivers-that-are-compatible-with-excel-for-mac-9fa6bc7f-d19e-4f7f-9be4-92e85c77d712

On a Mac myself, and understand that you need to install an ODBC driver first. Never had the need myself, so can't help with that, but it's described in the above links.

andreasbehr

Copper Contributor

Mar 16, 2020

danke, aber das klappt leider auch nicht. Ich bekomme gar nicht die Möglichkeit, dass ich eine lokale Datei auswählen kann.

Riny_van_Eekelen
Platinum Contributor
Mar 16, 2020
andreasbehr Because you don't have the ODBC driver installed. I get the exact same message on my system. You need the driver first before you can start connecting to externa data sources.
- andreasbehr
  Copper Contributor
  Mar 16, 2020
  Riny_van_Eekelen
  
  which driver did you install? I downloaded this one here: http://www.odbcmanager.net/about.php but it didn't work for me.
  
  Can you connect to a local file with the right ODBC driver?
  - Riny_van_Eekelen
    Platinum Contributor
    Mar 16, 2020
    andreasbehr Sorry, can't help you here. Don't use it myself. Just wanted to point you at the information hoping you could figure it out.