Solved: Change Source File Name Without Breaking All Links...

CarolinaJud · ‎03-03-2024

Hi,

I have a file which dozens of other files use as a source for power query. For various reasons, I need to rename the source file, but doing so breaks the link to all the files which use it.

I realize I can manually change the source for each file one-by-one, but I am hoping there is a more efficient way.

Is there? Any advice/suggestions appreciated.

watkinnc · ‎03-03-2024

Afraid not, so in the future, do something like name your source file something like "Z-SourceFile" (as an example), so that you can refer to the first file after sorting the folder by Descending A-Z, or something like that.

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

View solution in original post

watkinnc · ‎03-03-2024

Afraid not, so in the future, do something like name your source file something like "Z-SourceFile" (as an example), so that you can refer to the first file after sorting the folder by Descending A-Z, or something like that.

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

CarolinaJud · ‎03-09-2024

Hi Nate,

Thanks for the reply and answering my question to say that it's not possible.

Also, although quickly finding the file in Windows Explorer is not the reason I need to change the file name, your tip for quickly finding it is useful nonetheless. I will use it in the future.

Have a great day!