Linking Sheets On Network Shares
 

I have 1 Master workbook that pulls data from 6 Team workbooks. All of my
links work fine when they are all on my local machine. Whether in the same
folder or not. (I have tried both). That is to say, when I open the Master it
pulls the requested data from the other 6 closed workbooks. Not problems, no
pop-ups.

Now, I moved all 7 of the workbooks to a Network share and updated the links
accordingly. Now when I open that Master workbook, I get a message stating
that it contains links that cannot be updated. I can go to the EditLinks
windows and "Open Source" and it works fine. Once all 7 workbooks are open,
everything works.

How can I make this work, from a network share, with out the links breaking
and with out the other books being required to be open?

Unfortunately, I cannot use and VBA or Macros for this as our security will
not allow it.

--
Thank you,

Gregory