| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with INDIRECT function.
Using the INDIRECT function I'm trying to reference data in another Workbook.
However, if that workbook is not open the function returns a #REF! value. Open the Workbook it's referencing and it happily returns the vlaue I need. I understand it's one of the volatile functions in Excel, but I don't know why it won't return return the value if the other sheet is not open. Any ideas to help at all please?? TIA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
| include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
| INDIRECT Function - what am I doing wrong? | Excel Discussion (Misc queries) | |||
| INDIRECT function question | Excel Worksheet Functions | |||
| Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
Threaded Mode
