+ Reply to Thread
Results 1 to 5 of 5

Many users Edit links on a fileshare ???

  1. #1
    Registered User
    Join Date
    11-08-2007
    MS-Off Ver
    2021 Prof
    Posts
    84

    Wink Many users Edit links on a fileshare ???

    Hi .. I have a workbook that links to many other seperate workbooks.. all on the same fileshare
    When every new user comes on to start using the main workbook they have to go and edit the many links for the seperate worksheet.. and this is a very slow process.

    If a major update is done to the workbook they all have to go through the same process

    Is there a way that (once I have editied the links whe I install the workbook) the users dio not have to go through the same process??

    If there is it will make me and THEM very happy

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Many users Edit links on a fileshare ???

    have you tried playing around with the indirect() function, and then putting the various parts of your path in seperate cells for easier ediing?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-08-2007
    MS-Off Ver
    2021 Prof
    Posts
    84

    Re: Many users Edit links on a fileshare ???

    Hi .. not sure if that would help .. can you tell me a bit more ?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Many users Edit links on a fileshare ???

    if you have a sample workbook for us to look at, we could hekp a bit more

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Many users Edit links on a fileshare ???

    ok assume that you are IN book1 A1, referencing book2 A1, your fumula would normally be...

    =[Book2.xlsx]Sheet1!A1

    now, if you put the name book2 in B1, sheet1 in C1 and the cell refernence in D1 (if you want to add the cell ref), in book1 A1, you could use...

    =INDIRECT("["&B1&".xlsx]"&C1&"!"&D1)

    then whatever file name and sheet nale you enter, it will reference that file and sheet

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1