If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|