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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Uisng the Max and Index function to link to other workbooks
In article ,
Marilyn wrote: 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, =Max(Index(location of file\[name of file]sheet name!Cell reference) The reason the formula returns #REF! is that INDEX is missing an argument. By the way, since the formula is only referring to one cell, MAX isn't needed. If you need further help, describe what it is that you're trying to do. -- Domenic Microsoft Excel MVP www.xl-central.com Your Quick Reference to Excel Solutions |
Reply |
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 |