Sorry, I made the mistake of "assuming" since talking about the same power query refreshing with another open file but good point. The source file is...
I am posting along this thread as it has to do with a refresh issue with a file not associated with OneDrive (i.e. the source data file is on the loca...
Still not smart enough to figure out my mistake. However, all that I did was added an index column prior to the #"Expanded ADP with Drafted" and that...
Catalin Bombea said Seems to be slightly different, but I don't see why you have similar rows like 9-10-11, (only 1 with data), 14-18 (again only fi...
Ahh, good question. I did not clarify. That's because the "OF" position, each team has to carry 4. Another example would be the "SP" position; each...
See attached updated file. Would the same procedure here hold true for the "Roster Grid?" As you can see, I have a ton of queries to achieve what yo...
Let me clarify that last question about adding the "Round" column at the beginning. I know I could add a step and Column Index would accomplish this....
I appreciate. However, if you do not mind, in trying to "learn" here, I'm with you but two steps: The merged query, I'm not familiar with the...
It's a "grid" of players taken by each team, each round. Thus, in sheet "Grid Example," what would show in Round 2, cell B3, would be the player sele...
Correct, that's what I was able to figure out. I am pretty certain I was getting the original error because of the OneDrive sync client (i.e. the err...
Do not have to close the source file, just save it. Once saved, the refresh picks up all changes immediately in the other file and both files remain ...
Not sure about that. I disabled OneDrive and was able to achieve what I was asking. I can refresh the query while the source is open. Thus, OneDriv...