Keeping data once referenced workbooks are closed.
 

:mad:
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

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