Thank you so much for your determination and your help! I've changed that path in A1, and it's been "refreshing" for about 40 minutes. Granted, I had to open a couple of other workbooks and do other things in the meanwhile so I may be thinning the resources.

If I have to give up on it now, I may set it to refresh while I'm gone overnight and see if I get results.



Update: trying again, and instead of just hitting 'Refresh" on the table, I went into the Query after changing the path in A1. It's still taking a very long time to load. I want to see if I can further filter after your results come through to show only the folder paths that end in *Invoices. I don't think there's a way to use a variable in the A1 path like \projects\*\*Invoices, is there? The first * would be the project folder file name, and the second * would be anything that came before Invoices, in some cases a folder number like "2. Invoices".

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.