Indirect function
 

Dean,

You would have to open the source files and get the values, and paste them
into the cells.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dean Phillips" wrote in message
...
Hi,

As the known problem with INDIRECT is that the source worksheet has to be
open, has anyone got a bit of vba that will convert the cell formula to the
resolved indirect formula?

I have a spreadsheet that summarises several other files and the indirect
formula works but I don't want to email the source files as they are too
big. If the indirect formula were converted to hardcoded links I could
'break links' to convert the cells to values.