Jun 14 2021 07:11 AM - edited Jun 14 2021 07:20 AM
I have created an Excel spreadsheet that uses a UNC path to access and load data from another file. The UNC path works properly on the PC on which I had created the spreadsheet. When a co-worker (With a new Windows 10 PC) opens the spreadsheet with the UNC path link nothing will display (all files are open on the staff members PC) All three files reside in the same directory and the UNC path linking is pointing specifically to that directory. The staff member's old PC (Windows 8) had no issues opening the three files and updating the links with accurate data. Does Window 10 have issues using a UNC path in a cell formula for retrieving the values from the other files? Attached image is the working example from my Windows 10 machine using Microsoft 365. Staff member's PC is running Microsoft Office Standard 2019.
Jun 14 2021 07:20 AM
To be sure, are these folders are synced with OneDrive/SharePoint on any of these machines?
Jun 14 2021 07:24 AM