I currently send out files to inviduals where the majority of cells are locked, the only ones that are unlocked are for data entry. Within these files there are links. I email these files out to the individuals and they in turn complete and return. The problem is with my links. When the files are returned the links are changed from what I have on my file (location on network drive) to wherever they saved and worked on (eg their c drive) thus breaking my link. Is there a way to prevent this from happening?
Thanks for your time!
Thanks for your time!
Last edited: