name changes to linked workbooks
 

of I have several workbooks that are linked together. I want to save all them
with slightly different names (to show different versions) and make sure the
individual cells will update with the new names/paths. I've tried it once and
the cells did not seem to update. Any advice is welcome.

3putt,

(Does that mean you're a single or a double bogey?)

Just make sure that all the workbooks are open when any of them are saved
under different names.

HTH,
Bernie
MS Excel MVP


"3putt" wrote in message
...
of I have several workbooks that are linked together. I want to save all
them
with slightly different names (to show different versions) and make sure
the
individual cells will update with the new names/paths. I've tried it once
and
the cells did not seem to update. Any advice is welcome.

generally a bogey with the occassional par & double thrown in...pity...
thanks for the tip! - 3putt

"Bernie Deitrick" wrote:

3putt,

(Does that mean you're a single or a double bogey?)

Just make sure that all the workbooks are open when any of them are saved
under different names.

HTH,
Bernie
MS Excel MVP


"3putt" wrote in message
...
of I have several workbooks that are linked together. I want to save all
them
with slightly different names (to show different versions) and make sure
the
individual cells will update with the new names/paths. I've tried it once
and
the cells did not seem to update. Any advice is welcome.