| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping data once referenced workbooks are closed.
 I am able to get information from another workbook by referencing a cell containing the file name: =INDIRECT("'"&J38&"'!$B$12") In J38 there is: [K20060711.XLS]1 - General Statistics This works fine, until the file K20060711.xls is closed then all the data disappears. How do I remedy this? -- stuckupnorth ------------------------------------------------------------------------ stuckupnorth's Profile: http://www.excelforum.com/member.php...o&userid=31330 View this thread: http://www.excelforum.com/showthread...hreadid=560600 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking query | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Keeping data without losing Formula's | Excel Discussion (Misc queries) | |||
| Data from closed workbooks (pull func, indirect.ext, etc ....) | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Threaded Mode
