I have a summary workbook which links to a bunch of cells in an external
workbook. The external workbook's name is "01 04 2007 GDCS forecast & TCAPS
analysis"

However, every time this external workbook is modified, I like to change its
name to reflect the most recent update; i.e., if I were to modify the
workbook today I would change its name to "01 09 2007 GDCS forecast & TCAPS
analysis", etc.

Therefore, I'm wondering if there is a way (a macro, probably?) for the
workbook that links to this workbook to automatically change its formulas to
reflect the new workbook name? Hope that makes sense? I know I can do this
via the Edit--Links menu path but the person using this summary file is not
that expert with Excel, and I would prefer such updates to happen
automatically, if possible.

Dave
--
Brevity is the soul of wit.