| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel ignore file links that do not yet exist?
I have a set of formulae of the type below:
=SUM('V:\DailyReports\Brasil\2006\[BRA-2006-01-31.xls]EquipDataCollation'!$D$5:$F$5) I am transferring the generation of quarterly reports to others and wish to make it as easy as possible for them to update data. Therefore I would like to generate formulae of the form above relating to files that do not yet exist. The filename format is standardised. What I can't seem to get Excel to do is ignore formulae where the file it refers to does not exist yet. Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
| Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
| cannot open excel file, please help!!! | Excel Discussion (Misc queries) | |||
| Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
| How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Threaded Mode
