When pasting formulas to other WB, the references still linked to old WB ...
hi,
if I understand you right, you suggest I should replace all formulas
to a syntax excel doesn't recognise as formulas, do the WB change and
pasting, and then restore the formulas. i'll think about that. That
doesn't help the other users (not VBA users ...), of cource but could
help me from time to time.
The Name Manager do I use already, but there is the same: Other users
doesn't and they arn't even aware of the problem with the external
named range links.
It seem's like no solutions, if not anybody other have any
suggestions?
Kind regards
Tskogstrom
|