Excel file links stop working on other users Window 10

%3CLINGO-SUB%20id%3D%22lingo-sub-2444938%22%20slang%3D%22en-US%22%3EExcel%20file%20links%20stop%20working%20on%20other%20users%20Window%2010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2444938%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20an%20Excel%20spreadsheet%20that%20uses%20a%20UNC%20path%20to%20access%20and%20load%20data%20from%20another%20file.%26nbsp%3B%20The%20UNC%20path%20works%20properly%20on%20the%20PC%20on%20which%20I%20had%20created%20the%20spreadsheet.%26nbsp%3B%20%26nbsp%3BWhen%20a%20co-worker%20(With%20a%20new%20Windows%2010%20PC)%20opens%20the%20spreadsheet%20with%20the%20UNC%20path%20link%20nothing%20will%20display%20(all%20files%20are%20open%20on%20the%20staff%20members%20PC)%26nbsp%3B%20All%20three%20files%20reside%20in%20the%20same%20directory%20and%20the%20UNC%20path%20linking%20is%20pointing%20specifically%20to%20that%20directory.%26nbsp%3B%20The%20staff%20member's%20old%20PC%20(Windows%20%3CLI-EMOJI%20id%3D%22lia_smiling-face-with-sunglasses%22%20title%3D%22%3Asmiling_face_with_sunglasses%3A%22%3E%3C%2FLI-EMOJI%3E%20had%20no%20issues%20opening%20the%20three%20files%20and%20updating%20the%20links%20with%20accurate%20data.%26nbsp%3B%20Does%20Window%2010%20have%20issues%20using%20a%20UNC%20path%20in%20a%20cell%20formula%20for%20retrieving%20the%20values%20from%20the%20other%20files%3F%26nbsp%3B%20Attached%20image%20is%20the%20working%20example%20from%20my%20Windows%2010%20machine%20using%20Microsoft%20365.%26nbsp%3B%20Staff%20member's%20PC%20is%20running%20Microsoft%20Office%20Standard%202019.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2444938%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2444990%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20file%20links%20stop%20working%20on%20other%20users%20Window%2010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2444990%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72723%22%20target%3D%22_blank%22%3E%40Gerry%20Poppe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20be%20sure%2C%20are%20these%20folders%20are%20synced%20with%20OneDrive%2FSharePoint%20on%20any%20of%20these%20machines%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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  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.

2 Replies

@Gerry Poppe 

To be sure, are these folders are synced with OneDrive/SharePoint on any of these machines?

The files are located in a Network share. The other staff member was able to successfully use the file using her old PC Windows 8. When we moved her onto the new PC and Windows 10 is when the failure appeared. Our IT manager has indicated that nothing has changed on her rights or mapped drives which she had previously.