View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default External References

I was very careful not to embed external paths in a spreadsheet, but then I
noticed that afterwards, the entire path is now hard-coded in my formulae.
Is there an easy way to change formulae that have f:\mysub\mysub2\[myWB.xls]
in all formulae? What I would really like to do is have the formulae not
refer to a path at all.