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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping data once referenced workbooks are closed.
Hi, INDIRECT needs to have the 'parent' spreadsheet open to function. I used to have a document that did that same and the best way to keep the data is to select all your cells which use the INDIRECT function and Paste Special Values. Obviously this kills the formula, but it keeps the data. If you need the data to feed using INDIRECT you could paste the values into another worksheet. HTH, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=560600 |
Reply |
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) |