View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rushdhih rushdhih is offline
external usenet poster
 
Posts: 9
Default How to automatically make excel detect directory path for linked f

We have Reporting Tool that is in Excel with a lot of Linked Data files, the
problem is when we copy these files into another persons PC, the links refer
to the previous machine and all reference to it needs to be changed. This is
very time consuming considering the number of linked cells and files that
need to be changed.

Will appreciate, if any can give me a way to overcome this problem.

Thank you
Rushdhi