Hi,
I've noticed that when doing a paste link of a single cell, the resulting formula has absolute references. However, when doing a paste link of a range of cells the resulting formulas have relative references. I would like to maintain the abosolute references or avoid the automatic formula update of the relative reference so that my original formula's reference remains intact.

I have seen some solutions involving a brute force method of changing the original formulas to use absolute references but I'd like to avoid this. Are there any other ideas out there?

Thanks much for your help,
Gary