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?