How extensive are the folders below FPath?
Are we talking urls, sharepoint, or just the local hard drive?



Maybe, just perhaps… see here: Credentials problem | Excelguru Forums


The path in the named range FPath is used as a top, starting folder, but it doesn't have to be; the query could use it differently, but I don't think it would necessarily speed things up. The query I showed doesn't try to process further the results - I wpould expect the query to be added to for that. It was only meant as a starting point.

It's a rather large shared drive (1.99 TB) with lots of sub-folders and sub-sub folders. The funny thing is that the regular Power Query search from which I filtered for the folder paths that have *Invoices\ in them doesn't take nearly that long, so I guess your method is more complex. Appreciated, but I think it's just not going to be practical. I don't think it's a credentials issue, though.

Yup, last night I pulled it back up before I left and I attempted to add a filter to the results. It had all night to run, but I must have done something wrong as it came up empty. I'm tending to think I'll go with what I have, and if I need to look up a few file paths manually that were empty folders, I'll just keep those results in a file so I won't need to do too much in any month.