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

to

='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!!

./phil

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,

Philippe