| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Update of Source File Name
I am using a workbook that has many links to another file as below.
Unfortunately the source file name changes each day, with the new source file name being based on its creation date. How can I enter a function that will automatically update the file name (in bold) and takes into account that the source file name will be based on the previous working days date. ='[041107.xls]Front sheet'!$H$10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto update chart source reference | Charts and Charting in Excel | |||
| ** Links don't update UNLESS source file is open | Links and Linking in Excel | |||
| ** Links don't update UNLESS source file is open | Links and Linking in Excel | |||
| Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
| Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) | |||
Threaded Mode
