Excel linking to server, carrying usable link to other tabs

Occasional Visitor

I am working on a workbook that uses selection criteria to narrow options down and send it to a summary tab. I want to link the original file within excel as it's stored on the server for easy retrieval. How can I get this link to remain intact through multiple locations without always having to link it in each area? 

 

https://saberpower-my.sharepoint.com/:x:/p/natalie_brady/EV-Fz-LLVDtHnfa1m3MvqUEBRoCgYdoEHk7v3KlCpVS...

0 Replies