paste link
 

Hi, Is there any reason that a paste link would stop working, I have have
cells from one sheet paste linked to another,and for some reason they have
stoped working, is there a instruction that can be put in to stop them, or
some thing in options.
Thanks for any help, Barry.

paste link
 

One possibility is that the calc mode was changed from auto to manual.

Hit <F9 and see if the links update.

If they do, then:
<Tools <Options <Calculation tab,

And click on "Auto".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"wildauk" wrote in message
...
Hi, Is there any reason that a paste link would stop working, I have have
cells from one sheet paste linked to another,and for some reason they have
stoped working, is there a instruction that can be put in to stop them, or
some thing in options.
Thanks for any help, Barry.

paste link
 

Hi RagDyer, No it's not that, thanks any way.

"RagDyer" wrote:

One possibility is that the calc mode was changed from auto to manual.

Hit <F9 and see if the links update.

If they do, then:
<Tools <Options <Calculation tab,

And click on "Auto".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"wildauk" wrote in message
...
Hi, Is there any reason that a paste link would stop working, I have have
cells from one sheet paste linked to another,and for some reason they have
stoped working, is there a instruction that can be put in to stop them, or
some thing in options.
Thanks for any help, Barry.