Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Feb 2012
    Location
    St. Louis, MO
    Posts
    21
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Two linked excel files - How to get them to work on someone else's computer

    Hello Everyone,

    I have an excel file where a worksheet's cells reference another excel files data. I am able to get the excel file that references the other worksheet to work fine on my computer as my computer is able to read the path correctly, but when I send it to another employee they can not use the excel file because the path is not available on their computer.

    Can someone please tell me how to reference cells in seperate spreadsheet that is compatible with other users computers?

    Thanks for your help!

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Get the files out of your Documents directory and put them directly under the C:\ directory say C:\LinkedExecl.
    Have the other user put them in the same place on their machine. Of course when you move them on your machine
    you'll have to reset all the links once { Via Edit/Links in 2003 don't know where it is on the Ribbon yet!}but then you're good to go.

    Useful Links:
    Microsoft Delete Links Add-in.
    Find External links.
    Discription of Link Management.
    Last edited by RetiredGeek; 2012-03-02 at 17:57.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,819
    Thanks
    133
    Thanked 480 Times in 457 Posts
    Hi RG

    In Excel2007 and Excel2010, the 'Edit Links' is on the ribbons' [Data] tab, in the Connections section (second group from left in ribbon). It will be 'greyed out' if there are no links in the file you are looking at.

    zeddy

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Zeddy,

    Thanks!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,819
    Thanks
    133
    Thanked 480 Times in 457 Posts
    Further to RG's solution, if your 'linked file' is on a network server, it could be that the 'other person' does not have a 'drive mapping' or 'permissions' to the same folder as the required file.
    For example, on your PC the linked file might be in the folder, say, K:\xxxxxxx\yyyyyy\zzzzzzz
    So your other User just needs to check their drive mappings, and if it's not there, set one up or get IT to set it up for them (the network folder may require privileged access).

    zeddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •