| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what exactly prevents INDIRECT from accessing closed worksheets?
What prompted my question is the slowness and finicky nature of INDIRECT.EXT
on one hand and the inability of Harlan Grove's PULL function to deal with active cell addresses for copying formulas by dragging on another. For example, =PULL("'C:\[test.xls]Results'!A3") will work, but will give the same A3 value for all the dragged and copied cells, but =PULL("'C:\[test.xls]Results'!"&A3) is NOT allowed. So, what specifically prevents INDIRECT from accessing closed worksheets, and what would it take to enable this important functionality? z.entropic |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions | |||
| VLOOKUP from closed file using INDIRECT function | Excel Worksheet Functions | |||
| INDIRECT function do not work when other file is closed | Excel Discussion (Misc queries) | |||
| Use INDIRECT function to reference a value in closed file | Excel Worksheet Functions | |||
| Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
Threaded Mode
