| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
| Linking Master Workbook & subordinate workbook | Excel Discussion (Misc queries) | |||
| Linking in the same workbook | Excel Worksheet Functions | |||
| Linking sheets in the same workbook | Excel Worksheet Functions | |||
| Linking to workbook | Excel Worksheet Functions | |||
Hybrid Mode
