Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is there a NON-volatile version of INDIRECT ??
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 ?? |
#2
|
|||
|
|||
You can also set calculation to manual.
-- Regards, Peo Sjoblom "spiderman" wrote in message ... 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 ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excell 2003 will not open previous version | Excel Discussion (Misc queries) | |||
Indirect another wookbook | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
XML Source Menu Item disabled?? File version?? | Excel Discussion (Misc queries) |