Hi
If I understand you correctly (forgive me if I don't!) you can use Copy and
Paste Special Values on sums in exactly the same way as references. An
alternative is to select the cell(s) and hit F2, F9, Enter.

--
Andy.


"Marc" wrote in message
link.net...
Many of my references link to another work sheet and "paste special" gives
me absolute values but you can't at least that I know of use these easily
in
"sum".

Marc