Link to home
Create AccountLog in
Avatar of TechGuy_007
TechGuy_007Flag for United States of America

asked on

Excel SharePoint Linking

I am looking to migrate a client's on premise file server to SharePoint. Currently, they utilize quite a few macro-enabled Excel documents, most of which pull data from other workbooks through UNC pathing. A cell looking to reference another file looks something like \\server\folder\subfolder\file. I am trying to get this to work with SharePoint but I am unsure of the best way to do so. So far, pathing through the C drive (C:\User\{username}\OneDrive...) works perfectly, but it only works when I use a static username. I so far have been unable to get a username variable that pulls the currently logged in user to work... Any ideas on what I could do to get this to work properly?

Avatar of Amit
Flag of India image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account