Link to data from multiple closed files

  • Hi All!!

    I would like to link data from files stored on my local drive.

    As there many files I would like to link to all with same filename convention, I would like to drag the first cell and go from (row 1 to row 150)

    ='ADMIN:Excel:Item 00001.xls'!date


    ='ADMIN:Excel:Item 00150.xls'!date

    Any ideas on how I can do this? Also, I have some files 113 to 150 that do not exist as yet, how do I stop '#NAME?' from appearing, looks untidy?

    Many thanks for any help!!


  • Re: Link to data from multiple closed files

    Hi there!

    Thanks for your post unfortunately, the add-in is only available for Win machines, I use Mac OS X.

    Ideally, if I could have a column A with number 1 to 150 which would then be used to populate the formula in B which retrives data that would work however, I don't know whether it is possible to do that?

    A: 13
    B: ='ADMIN:Excel:Item 000013.xls'!date

    With 000013 being obtained from Cell A. bit tricky for and, any help would be muchly appreciated!!

    Many thanks,


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!