| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use of the Indirect function on a closed workbook.
I would like to use the indirect function to input data from various closed
workbooks. If I have the text "test" in cell A1, I would like to use the indirect function in cell B1 to obtain data from file "test.xls." I can do that, but when "test.xls" is closed, I get an error. I noted in a thread that there was a function I could obtain from the Web site "Morefunc for Excel" that would work with closed files. That web site no longer has a working link to that function. Any other sites or help? -- Surveymark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP from closed file using INDIRECT function | Excel Worksheet Functions | |||
| INDIRECT function do not work when other file is closed | Excel Discussion (Misc queries) | |||
| INDIRECT and Named Ranges referencing closed workbook | Excel Worksheet Functions | |||
| 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
