I'm using macro to move some Excel sheets (containing link
function) to another opening Excel file. but after the
move/copy sheet, i found the links was not right, as a
result, it show me the wrong data! What i have to do is
run the link function after i move/copy(using macro)the
sheet, than the data link is correct.
Is this the MUST procedure?
i tried to change the "reference style" to C1R1, but the
problem still occour.
Anyone can help? pls.