INDIRECT function

[Guest]

The INDIRECT function brings up a #REF! error if you try and reference a workbook that is closed, however it works fine if the workbook is open. Is there anyway around this problem?

 

[Aladin Akyurek]

No. Not with INDIRECT.

 

[Andrew XJ]

You can find from the Excel 97 help that the workbook referenced by INDIRECT muse be open. I don't know whether Excel 2000 has any improvement on this.

 

[Mark W.]

On 2002-02-25 07:05, Andrew XJ wrote:
You can find from the Excel 97 help that the workbook referenced by INDIRECT muse be open. I don't know whether Excel 2000 has any improvement on this.

No changes in XL2000. As always only absolute references to a closed worksheet will return a value.

 

[Andrew XJ]

To solve this problem, i use Autpen() to open the workbooks referenced by INDIRECT and hide the workbooks. Use Auto_Close() to close them. And force Autpen() and Auto_Close() to run them. Is there any other more efficient way?
This message was edited by Andrew XJ on 2002-02-25 07:39