paste link break down

[Sam]

Hi, I have two work books that are linked using paste special and paste link,
recently I have noticed that the links are not holding up, I key in figures
into one and it is not transferred to the other , this is happening more and
more often now, where as before say a month ago it worked fine.
Any Ideas any one?

Thank you in advance,
Sam.

 

[Gord Dibben]

Is your Calculation Mode set to Automatic?

Calc mode of first workbook opened in any session of Excel will govern the
calc mode for subsequent workbooks during that session.


Gord Dibben MS Excel MVP