Linking to another workbook
 

We have a workbook called LIST 2007.08 (for example), but every month for
auditors we save the workbook as LIST 06.30.08.

I have another workbook that has links to this workbook but the link needs
to change when we save it as 06.30.08, is there a way to have the link ask
the user which workbook to pull cell A1 from when they open the workbooks
with the links in it so it pull froms the new workbook 06.30.08?

Linking to another workbook
 

Have *both* WBs open when you save with the new name.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Susan" wrote in message
...
We have a workbook called LIST 2007.08 (for example), but every month for
auditors we save the workbook as LIST 06.30.08.

I have another workbook that has links to this workbook but the link needs
to change when we save it as 06.30.08, is there a way to have the link ask
the user which workbook to pull cell A1 from when they open the workbooks
with the links in it so it pull froms the new workbook 06.30.08?