| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Uisng the Max and Index function to link to other workbooks
I'm working on an Excel 2007 workbook which contains formulas to other
workbooks. Several of the columns in that file use the =Max(Index(location of file\[name of file]sheet name!Cell reference), however, if the file that the formula is closed then all I get in my results in #ReF but when the file that the formula references is opened then I get the actual results of the formula. Is this the default in Excel? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| uisng two paramaters for conditional formatting / Limiting screen size | Excel Discussion (Misc queries) | |||
| Uisng an option group query | New Users to Excel | |||
| INDEX and workbooks | Excel Worksheet Functions | |||
| calculating a weighted average uisng formula | Excel Worksheet Functions | |||
| index & match with links for updating to other workbooks | Excel Worksheet Functions | |||
Threaded Mode
