Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a filename that will automatically update if changed.
I have temporary file names that I need to enter into Excel, but I know later
on they will change. Is there any way to automate this so that when the files are renamed the spreadsheet will automatically update? This would be very helpful. Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a filename that will automatically update if changed.
See
http://mcgimpsey.com/excel/formulae/cell_function.html In article , JR wrote: I have temporary file names that I need to enter into Excel, but I know later on they will change. Is there any way to automate this so that when the files are renamed the spreadsheet will automatically update? This would be very helpful. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graph won't update when data is changed | Charts and Charting in Excel | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
How do I insert a partial filename? | Excel Discussion (Misc queries) | |||
Charts don't update when data is changed, why not? | Charts and Charting in Excel | |||
Insert value of a cell as a filename | Excel Worksheet Functions |