HI,
I'd like to Copy an entire worksheet from one file to another, but, I don't
want the file name to appear in the cell after Paste. For example
=[myfile.xls]Myworksheet!E5, I'd like to see only the cell reference:
Myworksheet!E5.

How can I get Excel do that?
--
AusTexRich