I have values coming into a worksheet by linking and formulas.

I was able to copy and retain those values into the new worksheet and let
them sum... the values paste fine and show correctly. However they no longer
sum. I manually have to reenter each number now.

I've tried reformatting etc, just can't figure out why they are ignored when
"paste special values" is used???

--
learning excel the hard way