Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to track mutual fund shares? | Excel Discussion (Misc queries) | |||
linking excel spreadsheet from network | Excel Discussion (Misc queries) | |||
How to return the Number of shares for a given stock code for a given portfolio | Excel Discussion (Misc queries) | |||
Excel 2000 with macros slows to write to W2k3/XP disk or shares | Excel Discussion (Misc queries) | |||
Excel Hyperlinks on Server mapped to other shares dont work. | Excel Discussion (Misc queries) |