When I link data on sheets of an excel workbook they don't work when I move
the workbook to another computer. How can I set up the links so that it will
work on any compter.
When I link data on sheets of an excel workbook they don't work when I move
the workbook to another computer. How can I set up the links so that it will
work on any compter.
Hi
I myelf use this technique:
When creating the link first time, I map the netwotk resource, where the
source workbook is situated, as drive. P.e. I map the share on server as Q.
Now the link p.e. to cell A1 on sheet Sheet1 in MyFile.xls in subfolder Data
will be:
='Q:\Data\[MyFile.xls]Sheet1'!A1
When the source workbook is moved to another share, I simply redefine the
mapping in user's computer - and the link will work as it did before. When
mappings are created localy, you have to visit every user's computer or to
send a mail with detailed instructions to every user. When all mappings are
created through script, when logged on into network, you have to edit PDC
logg-on scripts.
--
When sending mail, use address arvil<at>tarkon.ee
Arvi Laanemets
"Bob" <[email protected]> wrote in message
news:[email protected]...
> When I link data on sheets of an excel workbook they don't work when I
move
> the workbook to another computer. How can I set up the links so that it
will
> work on any compter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks