Use a query

Johannes Kingma · 25. Juni 2025

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
How to Safely Use FLVTO's YouTube Video Downloader How to Safely Use FLVTO's YouTube Video Downloader: FLVTO is a widely used online tool that allows users to convert and download YouTube videos into various formats, such as MP3 and MP4. It became popular due to its simplicity, fast conversion...	Neuigkeiten (Windows-Info intern)	22. März 2026
How to Safely Use YT1s YouTube Video Downloader. How to Safely Use YT1s YouTube Video Downloader.: YT1s is a popular web-based tool used to download videos and audio from YouTube. It gained significant traction because it is free, requires no software installation, and is relatively...	Software	16. Januar 2026
Is there a simple to use android emulator for windows desktop besides Bluestack? Is there a simple to use android emulator for windows desktop besides Bluestack?: All I want it for is the ability to run 1 app on my desktop. I have tried Bluestack until it just crapped out for some reason one day. Is there anything else out there that is very easy to install...	Microsoft Windows	3. Oktober 2025
Is Ovppyo free to use? Is Ovppyo free to use?: Yes, Ovppyo can be used for free, making it accessible to many people. Most of its basic features are available without cost, so you can start using Ovppyo without paying anything. But some of the...	Microsoft Windows	27. August 2025
Why Use a 16 Port FXS Gateway for Your Business? Why Use a 16 Port FXS Gateway for Your Business?: If your business relies heavily on voice communication but still uses analog phones, fax machines, or intercom systems, a 16 Port FXS Gateway can be a game-changer. It acts as a bridge between...	Allgemeines	4. August 2025
What is a 4 Port FXO Gateway and When Should You Use It? What is a 4 Port FXO Gateway and When Should You Use It?: I recently came across the term 4 Port FXO Gateway while exploring VoIP setups for a small office environment, and I was a bit confused. Most articles I read dive straight into marketing talk or...	Allgemeines	16. Juli 2025
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

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

How to Safely Use FLVTO's YouTube Video Downloader

How to Safely Use YT1s YouTube Video Downloader.

Is there a simple to use android emulator for windows desktop besides Bluestack?

Is Ovppyo free to use?

Why Use a 16 Port FXS Gateway for Your Business?

What is a 4 Port FXO Gateway and When Should You Use It?

Who can use TrimIQ?

Use a query solved