I have the solution! Crude but should work... When refreshing the queries programmatically, they seem to process in alphanumeric order based on the...
Ok, great. Thanks, Catalina. At least you've confirmed what I've found so far which is helpful. I tried to find code that would test if refres...
Hi Catalina, Thanks for this. Actually I do have that code in my routines and I run that code whenever the workbook opens (in case a future user/de...
I have had Out of Memory errors as well on one of my Excel projects. It is a reporter module for the partners of a law firm and it has Power Query pro...
Thanks, Mynda. (Quick turnaround!) Yes, I was thinking of that too but struggling with the concept of management seeing the dummy data. I didn't think...
Update: I tried the POSSIBLE WORKAROUND and it worked as at least one of the folders contained timesheets. Still, I'm curious if there's a way to d...