OK, My situation is. I need a way to link several workbooks on different drives. The first workbook gets changed everyday but saved as the same file name and share drive. However that same workbook needs to go to several other share drives. So there is a lot of save as and copying to a new drive. I don't think I an link because it is always a new workbook originally. Now the second part is that some of the other drives upload to a website so they need to not have all of the links and fomulas in it. Can this be resolved?