Uisng the Max and Index function to link to other workbooks

M

Marilyn

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,
 
D

Domenic

Marilyn said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top