Since it sounds like you probably already know how to do it with sheets
within a single workbook, or between sheets in multiple workbooks on the same
drive, I'm going to give the short answer:
Open all of the workbooks and set up the formulas / links while they're all
open. If you think of them as all being in one huge workbook while all are
open, then you can get the job done easily and Excel will set up the proper
addressing in the formulas for you and change them properly when you close
the workbook that's linked to the others.
Lets say you want to set up a formula in cell A1 on MySheet in WB1.xls that
references cell B9 on ThatSheet in WB2.xls.
Start by choosing cell A1 on MySheet and type in the = symbol. Then use
Window from the menu to select WB2 and go to sheet ThatSheet in it and click
in cell B9 and press [Enter] (or type the next part of a formula) and you
will have the reference set up as you need it to be.
Hope this helps.
Now if you're trying to set up links in one of the files that's on the
shared drive to a file on your 'personal' drive, it's more problematic since
your personal drive may not be shared on the network and no one will be able
to access it and the reference to it will probably reference the file as
C:\....\...\WB1.xl and that file probably isn't going to exist on their C:
drive or even if there is one of the same name in the same folder, it
probably won't have the proper information in it. In that case, about the
only thing to do is to put a copy of the file from your personal drive onto
the share and set up the links using the copies that are on the share.
