Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT function
I have a series of files in the same directory and wish to interrogate them
from a summary file. I have been advised the the INDIRECT function will do the trick and it works fine as long as the source file is open. I have seen from other postings tghat INDIRECT.EXT works with closed files. I have downloaded morefunc and using INDIRECT.EXT I still get the same result, ie the formula gives the correct result when the source file is open but gives a #REF! response when the file is closed. the formula I am using is =INDIRECT.EXT("[Losses"&B5&".xls]Sheet1!B4") where Losses11.xls is the source file and B5 contains 11. If I remove the ".EXT" from the formula it works in exactly the same way. I have removed all spaces from the filenames. Regards Ernie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT function
If the file is closed, you're going to have to add the drive and path to the
formula. Ernie Fenwick wrote: I have a series of files in the same directory and wish to interrogate them from a summary file. I have been advised the the INDIRECT function will do the trick and it works fine as long as the source file is open. I have seen from other postings tghat INDIRECT.EXT works with closed files. I have downloaded morefunc and using INDIRECT.EXT I still get the same result, ie the formula gives the correct result when the source file is open but gives a #REF! response when the file is closed. the formula I am using is =INDIRECT.EXT("[Losses"&B5&".xls]Sheet1!B4") where Losses11.xls is the source file and B5 contains 11. If I remove the ".EXT" from the formula it works in exactly the same way. I have removed all spaces from the filenames. Regards Ernie -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect Function | Excel Worksheet Functions | |||
How to use indirect function? | Excel Discussion (Misc queries) | |||
using the INDIRECT function | Excel Discussion (Misc queries) | |||
INDIRECT function inside AND function | Excel Worksheet Functions | |||
INDIRECT Function | Links and Linking in Excel |