Re: 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" <Susan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F79AAFD7-A871-4083-B6AA-47507D8775B3@xxxxxxxxxxxxxxxx
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?



.



Relevant Pages

  • Re: new cell for each day
    ... Microsoft MVP Excel ... "Libby" wrote in message ... another workbook that I pull. ... so if today is the 6 then it will pull cell ...
    (microsoft.public.excel.worksheet.functions)
  • Re: new cell for each day
    ... "Don Guillett" wrote: ... INDIRECT only works with OPEN workbooks. ... another workbook that I pull. ... so if today is the 6 then it will pull cell ...
    (microsoft.public.excel.worksheet.functions)
  • Re: new cell for each day
    ... Libby wrote: ... I am trying to use the date cell in one workbook to determine what cell of ... another workbook that I pull. ... so if today is the 6 then it will pull cell ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Data validation with Excel 2004 on Mac OS X
    ... Please keep all correspondence within the NewsGroup, ... > In xl2003, if I used a sheet level name Listmasters!cat, ... > same worksheet or have a workbook level name for windows ...
    (microsoft.public.excel)
  • Re: Dynamic range for Table_array in a VLOOKUP.
    ... Regards, ... workbook name that you're getting to. ... > Please keep all correspondence within the Group, ... >> Where you enter the sheet name in A11. ...
    (microsoft.public.excel.worksheet.functions)