| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to a linked file
Hi. I have two files to which I would like to link cells to. Each week, the
file names will change based on the week number. The name of one file is the current week (for example Week 3.xls). The name of the other file is always one less than the first (for example Week 2.xls). Is there a way to do math within the cell reference? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
| Linked value to cell in different workbook + Relative File Reference | Excel Discussion (Misc queries) | |||
| Linked File Calcuation req. source file to be open | Excel Discussion (Misc queries) | |||
| In a linked calculation how do I lose the '0' in the linked file? | Excel Worksheet Functions | |||
| Dynamically-linked formula, cell reference in the string | Excel Worksheet Functions | |||
Threaded Mode
