refer cell value of another workbbok in formulae

A

Abhay

Hello!

Indirect() function requires that workbook being referred in formulae should
be open.
I would like to change reference in formulae without opening the workbook.

Thanks in advance.
 

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

Indirect formula errors if file is closed 0
offset formula causing Circular reference 0
Is there a function to count how many times a cells value is used? 0
Referencing an External Cell 1
trouble with (complicated) vlookup searching another workbook 2
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Reference Cell Altering Formulas 1
Copy addition formula of non-consecutive horizontal cells 2

Top