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