Get.Workbook(1) + Other Files

Hello

Can I somehow wrap the "=GET.WORKBOOK(1)" function used with Name Manager to get the workbook and sheet names of 'other' excel files (not the active workbook) if I have the file path of each file ?

I am trying to create a list of SHEET names from numerous excel files.

Thanks

Yes but the other workbook needs to be open

Please Login or Register  to view this content.

excellent thank you.

I am using this now as "=GET.WORKBOOK(1,ShPt_List_Query[File.Name])" using power query to get a list of files on a share point site showing them as a table and referencing in the NAME

Works great but it only give me the first sheet on each workbook - is there a way of expanding to get all sheet names ?

How about

Formula:

Please Login or Register  to view this content.

Another option depending on how you want to display the sheet names

Formula:

Please Login or Register  to view this content.