Use a query

Johannes Kingma · 25. Juni 2025 um 17:12 Uhr

I have a queryHow do I use the result in a Sheet? Copilot could not help me here.

Pauline R.

Hallo,

leider weiß ich nicht, welches Add-In du meinst, ein MS Query Add-In kenne ich nicht.

Falls du das hier meinst, das gibt es in Excel 2013 auch noch und dafür ist kein Zusatz-Add-In erforderlich:

http://office.microsoft.com/de-de/excel-help/use-microsoft-query-to-retrieve-external-data-HA010099664.aspx

Microsoft Power Query und PoverPivot sind nur für die von mir in meiner ersten Antwort genannten Versionen verfügbar. Mit deinem Office 2013 Professional kannst du die Add-Ins nicht nutzen. Wenn du die Add-Ins benötigst, musst du dir eine Office Version
kaufen, die diese Add-Ins unterstützt.

Gruß,

Pauline

Andreas Killer

Entweder benutzt Du die FILTER Funktion und filterst die Daten in einen anderen Bereich (anderes Blatt) oder benutzt Power Query um die entsprechenden Datensätze zu filtern.
https://support.microsoft.com/de-de/office/filter-funktion-f4f7cb66-82eb-4767-8f7c-4877ad80c759
Filter a table (Power Query) - Excel
Dann erstelle das Organigramm aus dem gefilterten Datenbereich neu.
Andreas.

Andreas Killer

Mit Power Query alle Daten importieren
 Power Query aka Get & Transform
 Und dann die entsprechende Spalte filtern
 Filter a table (Power Query) - Excel
 Ich mutmaße mal das mit "Mappe" eine Datei gemeint ist, welche dann ja auch mehrere Blätter haben kann...
 ich denk das Video unten ist hilfreich.
 Andreas.
 https://www.youtube.com/watch?v=yL11ugShdrk

Andreas Killer

Use Power Query and simply filter the data as needed:

Get & Transform

Andreas.

Andreas Killer

beim Importieren von CSV oder txt Dateien wird immer ein Autofilter angewendet.

Wie machst Du das denn?
 Power Query - How to import a CSV file that does not match your locale - Microsoft Community
 Andreas.

Hi,

willkommen im Windows Forum!

Use a query - Similar Threads - Use query	Forum	Datum
Who can use TrimIQ? Who can use TrimIQ?: TrimIQ is a UK-based, medically supervised weight loss program that offers a modern, convenient approach to managing weight. By combining prescription medications such as Wegovy, Mounjaro, and...	Microsoft Windows	16. Juni 2025
Is it safe for daily use? Is it safe for daily use?: Glyco Forte is a premium natural supplement carefully formulated to support healthy blood sugar levels, enhance metabolic function, and promote overall wellness. Combining a synergistic blend of...	Microsoft Windows	10. Juni 2025
What is a GSM Gateway and Why Should Businesses Use It? What is a GSM Gateway and Why Should Businesses Use It?: A GSM Gateway is a device that links a business’s telephone system (like a PBX or VoIP system) to the GSM mobile network. It uses SIM cards to connect calls between landlines or internet telephony...	Hardware	5. Juni 2025
Assign Sub-Tasks or workaround for use case where this is needed Assign Sub-Tasks or workaround for use case where this is needed: Is there in fact no possibly to assign sub-tasks in planner to other people? This makes the tool practically useless. It is available in the free version of Monday and Asana.Scenario of Managing...	Microsoft Office	20. Mai 2025
What is a 4 Port FXS Gateway and Why Would a Business Use One? What is a 4 Port FXS Gateway and Why Would a Business Use One?: A 4 Port FXS Gateway is a type of VoIP gateway that connects traditional analog telephones or fax machines to a VoIP (Voice over IP) network. The term "FXS" stands for Foreign Exchange Subscriber,...	Allgemeines	19. Mai 2025
most effective use of tadalafil does cialis work better the more you use it most effective use of tadalafil does cialis work better the more you use it: . . Is there anything better than cialis ==> https://tinyurl.com/CialisTadalafil24 . . . . . what dose of cialis works best is there anything better than cialis is there anything...	Microsoft Windows	13. Mai 2025
can cialis 5mg be taken daily when to use cialis 5mg daily can cialis 5mg be taken daily when to use cialis 5mg daily: . . When to take cialis 5mg . . . . . can cialis 5mg be taken daily what is the best time to take cialis 5mg uses of tadalafil 5mg uses of tadalafil 5mg uses of cialis 5mg uses of...	Microsoft Windows	13. Mai 2025

Use a query

Use a query

Office 2013 Professional - MS Query und Power Pivot fehlen!

Visio-Organigramm auf Excel-Basis: Nur eingeblendete Zeilen abbilden

Excel Liste - seperate Mappe mit gesammelter Übersicht

Excel Fromula

Excel Import csv oder text ohne Autofilter

User Advert

Use a query - Microsoft Office

Use a query - Similar Threads - Use query

Who can use TrimIQ?

Is it safe for daily use?

What is a GSM Gateway and Why Should Businesses Use It?

Assign Sub-Tasks or workaround for use case where this is needed

What is a 4 Port FXS Gateway and Why Would a Business Use One?

most effective use of tadalafil does cialis work better the more you use it

can cialis 5mg be taken daily when to use cialis 5mg daily

Use a query solved