User Name formula - Non-VBA

[KillerOfGiants]

Hello all,

I am using the following formula to extract the user name in an excel file. I cannot use VBA. The file is on SharePoint and has links to other files (both csv and xlsx files). The file path to the linked files is different based on the user that is utilizing the data. I have found the following formula to extract the UserName that is using the file, which determines the file path. It worked fine, for awhile. It broke Friday, but we thought it was just a SharePoint hiccup. But now, it won't work at all for one of the users. When I look at the UserName when I have the files open (linked files are open to extract data, so not having that issue), my username shows correctly. The other user's name shows as just the c prompt (C. I have no idea why it started doing this when it was working before. The only thing I wonder is if it is because this user has a space in their user name, whereas the other two users, there is no space.
The UserName formula is: =LET(fullpath, INFO("DIRECTORY"),path, SUBSTITUTE(fullpath, "C:\Users\", ""),LEFT(path, FIND("\", path) - 1))

Any and all help is greatly appreciated.

 

[KillerOfGiants]

A little bit more information. Evaluation of the formula reveals that the other user is no longer pulling the same DIRECTORY path.

The first step in when I run the formula evaluates as follows: C:\Users\MyUserName\Documents\
The first step in when the other user evaluates as follows: C:\Windows\system32\

This is where the break is occurring. We are both opening the files from the same locations in SharePoint. But the formula evaluates (now) differently for the other user. This worked for quite some time initially, but now it does not.

 

[Cubist]

Try =CELL("filename") and see if this gives you a more consistent directory.