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,

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