Bernie,

Weird. That worked. I shouldn't have to do that should I? Like I said
it's been a while since I built anything significant in Excel, and this is
now on a new machine. However I'm sure I never had to do that in the past.
A copy followed by a paste previously held the relationship to the
originating spreadsheet without having to jump through the hoops we did here.
Is this a known bug?

Thanks very much for your help. - russ

"Bernie Deitrick" wrote:

Russ,

Instead of copy and pasting, try

1) copy / pastespecial link.

2) cut then paste, then close the workbook from which you cut the cell
without saving changes.

HTH,
Bernie
MS Excel MVP


"xrbbaker" wrote in message
...
Grettings,

I haven't played with Excel for several months... I'm copying an area from
one spreadsheet file, and pasting it into another spreadsheet file. What
I
expect to happen is that the pasted cells will retain their link to the
source spreadsheet. Instead what is happening is that the cells contain
the
formula of the source cell which then wreaks havoc on my spreadsheet
because
that formula makes no sense out of the original spreadsheet. Is there a
setting somewhere that must be off? Why are the pasted cells not
retaining
the fully qualified path back to the originating source?

Thanks - Russ