Using Power Query to Retrieve File Names and Metadata While the FILES function is a powerful tool for listing files, Excel offers an alternative method through Power Query. Power Query is a robust ...

open Excel, select "File," click on the "Info" tab and click "Managed Versions." Then select "Recover Unsaved Documents." Look for the worksheet's file name under the "Versions" heading.

Step 2. Enter the name of the file. The finder will begin searching automatically. Step 3. If you do not know the name of the missing Excel file, you can instruct Finder to display all Excel files ...

Quick tip: Excel files can only be opened by Excel or ... you may need to click a drop-down menu to the right of the "File name" field. If it's currently set to "Text Documents," change it to ...

It will also display Table names. Load the empty sheet into Power Query. 6. Click Transform Data to launch Power Query. For now, Power Query looks empty. How to expose the Excel file’s metadata ...