Forum Discussion

CarolinaJud's avatar
CarolinaJud
New Member
2 years ago
Solved

Change Source File Name Without Breaking All Links?

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.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

    • CarolinaJud's avatar
      CarolinaJud
      New Member
      2 years ago

      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!