Using the Indirect.Ext function

H

henryhbb

The original reference works fine even if the source workbook is closed
Does anyone know of a way to change the reference based on a vaule i
another cell
 
F

Frank Kabel

Hi
was this your first reference?
='K:\ACCTG\25 BUDGET\Department Budgets\GAMES 2005.xls'!Jan
'K:\ACCTG\25 BUDGET\Department Budgets\GAMES 2005.xls'!PR

This looks at least for me like two references.
In addition as said you CAN'T use defined names with INDIRECT.EXT and
closed workbooks. e.g. your defined name 'Jan' is not available if the
workbook is closed. No way around this. Use a range reference such as
A1:A100 instead.
So if for example C179 has the value
A1
try
=INDIRECT.EXT("'K:\ACCTG\25 BUDGET\Department Budgets\GAMES 2005.xls'!"
& C179)

There're several restrictions then dealing with closed workbooks and
this kind of functions!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Turning off automatic calculation 0
Indirect.EXT download dosn't exist 3
Using SUM with INDIRECT.EXT 1
INDIRECT function 1
INDIRECT.EXT 3
Cross reference drop down not activating 1
INDIRECT.EXT with vector reference 5

Top