Have tried to copy range of cells containing formulas, to another worksheet,
but can only manage to save values only by 'paste special'. The formulas
lose their links and display REF!
What I want to do is copy the whole range, retaining the links in the
process. This would be the equivalent of entering a formula in each
dependent cell and linking to the corresponding cell in the source worksheet.

Is it possible to do this across multiple cells (a range) in one go?

On Jul 23, 11:22 pm, Twishlist
wrote:
Have tried to copy range of cells containing formulas, to another worksheet,
but can only manage to save values only by 'paste special'. The formulas
lose their links and display REF!
What I want to do is copy the whole range, retaining the links in the
process. This would be the equivalent of entering a formula in each
dependent cell and linking to the corresponding cell in the source worksheet.

Is it possible to do this across multiple cells (a range) in one go?

Somewhere, but I cannot find it tonight, there's a way to change ALL
nunber in a worksheet to Absolute ( with the $ sign in front). Then
when you copy they don't change. If you want them dynnamic again you
can use the Find menu / Find / Replace and put $ in the Find window
and leave the Replace With window blank. The Find Replace won't work
when there's nothing but a blank space to change.

ed

In om, ed
spake thusly:

Somewhere, but I cannot find it tonight, there's a way to change
ALL nunber in a worksheet to Absolute ( with the $ sign in
front).

Gord Dibben just posted his macros to do this. They are in
this group, findable with the following information from that
article:

From: Gord Dibben <gorddibbATshawDOTca
Subject: Changing all formulae in a worksheet from absolute to relative
Date: Mon, 23 Jul 2007 15:48:57 -0700
Message-ID:

(They look good to me; I've saved them for future reference. Thanks,
Gord!)

Dallman

One method.....................

EditReplace

What: =

With: ^^^

Replace all.

Copy the range to the other worksheet and reverse the process.


Gord Dibben MS Excel MVP

On Mon, 23 Jul 2007 21:22:03 -0700, Twishlist
wrote:

Have tried to copy range of cells containing formulas, to another worksheet,
but can only manage to save values only by 'paste special'. The formulas
lose their links and display REF!
What I want to do is copy the whole range, retaining the links in the
process. This would be the equivalent of entering a formula in each
dependent cell and linking to the corresponding cell in the source worksheet.

Is it possible to do this across multiple cells (a range) in one go?