How to maintain Sharepoint URL absolute path instead of relative path?

Question

Hope everyone reading is well, my department is migrating to sharepoint from a local server, and we are experiencing some problems with our files and its references.

We have several excel files that have graphs and charts, and we paste those in a powerpoint presentation, until that part everything is fine, the problem comes when we want to edit the links of those charts to another excel file that has the same chart, but with updated information (we keep historical files in order to keep control). When we change it, the absolute path containing the sharepoint URL changes to a relative path as if the document were locally, but still referencing the sharepoint folders, if another user tries to open that file it says it does not exist.

This is a problem when multiple users are working on the same file, we need to be able to keep the sharepoint URL so when other team members want to check or edit the links and files everything is linked through the absolute URL path.

I checked and there is no information online on keeping absolute paths for the files.

Answer 1

George,

I'm experiencing a similar issue with all VBA code written for Excel files that are now in Sharepoint. There is a serious lack of functionality within VBA for Sharepoint. Things like "FileCopy" that used to allow me to copy/rename a file in my drive are now completely useless with Sharepoint filepaths. So many macros are now rendered useless because Microsoft decided to "update" things and encourage cloud usage in Sharepoint (which works great for some things). However, this should not come at the cost of having to redo and recreate new macros and automations to move to the cloud. Microsoft owns both VBA and Sharepoint--it should've thought of these effects before rolling something like this out. If there's a solution that DOES NOT require us to turn off collaboration settings and STILL gives us the same VBA functionality, please let me know

Thanks,

Jared

Answer 2

Hi Jared,

Thanks for posting in the community.

Since your query is related to VBA in SharePoint files, I recommend you refer to this article: Office VBA support and feedback | Microsoft Docs to go to Stack Overflow by using the VBA tag, along with any other relevant tags as there are also many experienced engineers and experts in the forums there.

Sincerely,

George | Microsoft Community Moderator