is there a NON-volatile version of INDIRECT ??

S

spiderman

hi,
i want to use a function like INDIRECT ( ) as a quick way to change the
reference of a cell in many formulas.... but INDIRECT is volatile and causes
re-calculations just anytime i make a change to the workbook and this is a
biiiiig file so it i can take a while. so is there a NON-volatile version of
INDIRECT ??
 

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

volatile v non-volatile 4
SUMIF and INDIRECT reference to tab in other workbook 3
Using 'indirect' function with full network path 0
INDIRECT 3
Today - volatile function 3
Copy addition formula of non-consecutive horizontal cells 2
Formula Simplifications Using Nested If, Indirect & Address Functi 3
alternative to INDIRECT reference 3

Top