Keeping data once referenced workbooks are closed.

S

stuckupnorth

: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?
 
S

SamuelT

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
 
Top