Linking Sheets On Network Shares

G

Gregory Day

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 Edit>Links
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top