Keeping data once referenced workbooks are closed.

  • Thread starter Thread starter stuckupnorth
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing cells in closed workbooks 1
Referencing Data in Closed Workbooks 4
referencing cells in different workbooks 2
Dynamic referencing to files 4
Indirect and sumif functions with multiple workbooks 1
Excel sum if and closed workbooks 2
HELP REQUIRED: Vlookup VS separate Workbook 2
Error when Formula references a pivot table in an external workboo 2

Back
Top