Reboot or restart Excel. What you are doing should produce the right results. If that fails you may want to consider reinstalling the application. It ain't behaving right. The formula, from what you say, reads the same in the cell whether you hand-type it or paste it, but if you paste it it counts the old values instead of the new relative ones.

You could try working around by going to the Paste Special menu and choosing formulas, but that's what it is supposed to be doing by default anyway.


A