| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDIRECT function do not work when other file is closed
I have used INDIRECT function which has reference to other workbook. when I close other book which I have referenced to. INDIRECT function do not update values, instead it gives error. is there any other function for the same working which would update values even when other file is closed. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=541508 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| file will not open | Excel Discussion (Misc queries) | |||
| default save as file type does not work | Excel Discussion (Misc queries) | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Does file need to be open for INDIRECT to another workbook to work | Excel Discussion (Misc queries) | |||
Threaded Mode
