I have many excel worksheets that link to other worksheets. Some link by drive letter mappings and others have a UNC name. Is there a way to link without using the UNC name? Concern is what to do if the linked server is changed. Do we have to go through each spreadsheet and change the link? Or is the option to write a macro that will do a find and replace? Thanks
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!