Keeping data once referenced workbooks are closed.

[stuckupnorth]

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?

[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