Excel trying to open file from someone else's desktop

Hello all,

I inherited a file that has some VB code that automatically pulls the latest data from servers and refreshes the file. However, the issue is that one of the files it's trying to open is/was on someone else's desktop, and this file now can't find it. The error I receive when I open the file is as follows:

Sorry, we couldn't open 'https://companyname. sharepoint.com/Users/<username>/Desktop/foldername/business_plan_xlsm. 

How do I stop Excel from trying to open that file. I have not been able to locate the exact place where that command is coded.

Thanks,

Sahar