Share via

Folder names are automatically changing for linked files on Sharepoint

Anonymous
2024-09-25T05:33:24+00:00

I have a file A that links to file B in the "August" folder. Once i create a copy of file A into a new month's folder for September but in the same SharePoint folder, it updates the path link for file B from August to September automatically. Since file B is not in the September folder, it does not open or have the link in place. Why is excel automatically changing the folder name? See below screenshot

I cant upload screenshots due to upload restrictions but the path names are pasted below

Link in my August file =xxxxxxxx/Documents/xxxxxx/OSOS/2024-25/05. August 2024/Submissions/[Forecast - Aug 2024.xlsx]forecast'!W234

Link automatically changes to September folder

=xxxxxxxx/Documents/xxxxxx/OSOS/2024-25/06. September 2024/Submissions/[Forecast - Aug 2024.xlsx]forecast'!W234

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-09-25T07:05:13+00:00

    Hi RohitBah,

    I tried to deploy some tests to better investigate the scenario you are facing, but it seems like the linked file path is not same as yours. May I confirm if all workbooks are saved in a SharePoint site with document folders naming August and September? Please correct me if I'm in the wrong way.

    Meanwhile, I have opened the private message channel for you and give it a try if you can successfully upload images from there so that we can troubleshoot this scenario more efficiently to save your time. Click: Private Messages - Microsoft Community

    Best Regards,

    Mia

    0 comments
  2. Anonymous
    2024-10-09T04:51:54+00:00

    Can someone help with this?

    As an example:

    • Destination file A is in folder 05, August 2024 with a link to a source file called file B in same folder 05. August 2024.
    • I then create a copy of destination file A in a new folder called 06. September 2024.
    • When i open this newly copied file, instead of keep the link to file B as is, i.e. in folder 05. August 2024 it changes the path to try and read it from folder 06. September. The file obviously does not exist in this new folder so when i try to open the file directly from the link in the cell it shows an error
    0 comments
  3. Anonymous
    2024-10-09T07:16:07+00:00

    Hi RohitBah,

    Thanks for your detailed sharing, it seems like I can reproduce a same behavior, and I sent you some details and test screenshots in our private message. Kindly check it when you are available. Hope you a nice day and stay well!

    Best Regards,

    Mia

    0 comments