•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Referencing local file instead of on `disc or network
Our take
When working with Excel and XLOOKUP, maintaining consistent file references is essential, especially when sharing files across different computers. To avoid including personal file paths like OneDrive links, ensure that all relevant files are located within the same folder. Instead of using network paths or complex references, you can simplify your XLOOKUP formula by specifying just the file name and range, such as: `=[Membership 2026-04-18.xlsx]2026-04-18!$C:$C`. This approach allows for seamless collaboration without the confusion of varying local structures.
I have an XLOOKUP where Excel wants to add unnecessary reference such as:
=XLOOKUP(I64,'https://d.docs.live.net/[deleted]/Documents/[Membership 2026-04-18.xlsx]... or
=XLOOKUP(I64,'C:\Users\[deleted]\OneDrive\Documents\[Membership 2026-04-18.xlsx]... Since a fellow club member will be using this file on his computer, references to my OneDrive account or local structure can't be included in the formulas because hsi computer is different from mine.
All files will be in the same folder. I've tried to reference these files like this:
./[Membership 2026-04-18.xlsx] but Excel won't accept this.
This is what I want:
=XLOOKUP(I3,'[Membership 2026-04-18.xlsx]2026-04-18'!$C:$C,'[Membership 2026-04-18.xlsx]2026-04-18'!$A:$A) How do I make this file play nicely with other files in the same local folder?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience