Cell Paste using cell link option Half works

[MardiT]

Hello, for the life of me I can not figure out what is wrong. I have used
this feature in the past without problems. I have copied and pasted the
contents from one cell one worksheet one workbook to another cell, another
worksheet, another workbook. I make the correct references but somehow $A$3
will not copy to it's new location. But, $B$3 will copy each time; from the
original location to the new location. Both have numbers and I am going from
number field to number field each time (cell definition). Ny hints? Thank
you

 

[John C]

Are you getting anything in the cell $A$3? Are you getting an error message?
Do you have any VBA code that might be interfering?

 

[MardiT]

Hi John,

I receive the value of 0 (zero). Each and every time. Now, If I
open the file The one that has the value greater than zero in of $A$3), then,
that value will be written correctly into the other file, but I should not
have to do that. I run a new file each day and I have the correct file name
(a different file name) listed for each day.

I have tried and tried looking at all the characters and making sure
that no ctrl keys got in the way...all that stuff. Is there some kind of
"Microsoft Magic" going on??

Thank you so much for taking my case.

 

[Spiky]

Excel doesn't calculate or update links the way you want, welcome to
the club. Some formulas update easily, others do not. Supposedly there
are rules, but it doesn't seem to always follow them. Perhaps that is
what you mean by Microsoft Magic.

The answer is to update the links, easiest by opening the source file.
If it is a constant mess, you could use a macro to do it, put a button
in the file to run it easily. The macro would open the source,
calculate, close the source.

It could possibly also be affected by how Excel changes formats when
copy/pasting. You may need to check formats after the paste, not just
before.

 

[MardiT]

Spiky,

Thank you. I am not familiar with Macros. I have done some via using
the record and then "tweeking" from there, but I'm no pro. Thanks. I will
give it a try. thank you both.