when working out the details I often "perfect a formula in one workbook and
then paste it into another. However, I can not find a wyanot to paste the
formula with ref. to the first notebook. I then have to spend more time
deleting references. Its a bit of a hassle.

Is there a way not to paste the ref. to the first workbook?

Thanks

Tom