we have a lot of files in sharepoint that many users work whit. This fliles used to be in a shared folder in a server, and the vlookup function worked fine.

Now we have thos same files in sharepoint, if we sinc the files to a local folder for the user A, the user A can use the VLOOKUP function, but it only works for the user A becouse the VLOOKUP function takes the path of the pc of user A, when a user B sincs the file, the file shows an error cuse the VLOOKUP function points to a path that dont exists in the pc of user b.

Any ideas or we have to go back and have it in a shared folder in a server?