Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
Formatting not retained using paste all and paste link | Excel Worksheet Functions | |||
"paste special" "paste link" | Excel Discussion (Misc queries) | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) |