Using SUM with INDIRECT.EXT

G

Guest

I am trying to sum up a range of cells in an unopen, external worksheet.
Using INDIRECT.EXT, I have only been able to do so if the row number of the
beginning cell is less than 100. For example,

=SUM(INDIRECT.EXT("'C:\[MyBook.xls]MySheet!b99:b704"))

will work. However,

=SUM(INDIRECT.EXT("'C:\[MyBook.xls]MySheet!b100:b704"))

will work only for an open worksheet, not a closed one.

Additionally, if the ending cell row is 1000 or more, regardless of the
beginning cell, the formula will not work for a closed workbook.

Does anyone know if this problem can be solved, so that I can use
INDIRECT.EXT with SUM over the full range of a worksheet?
 
H

Harlan Grove

hmm said:
Additionally, if the ending cell row is 1000 or more, regardless of the
beginning cell, the formula will not work for a closed workbook.
Click to expand...
....

I can't replicate this problem. IOW, SUM(INDIRECT.EXT(..)) returns
expected results whatever the starting and ending rows are. Are you
sure you're using the latest version of MOREFUNC.XLL? The current
version is 4.2 released 5 March 2006.
 

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

Similar Threads

Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
INDIRECT.EXT with vector reference 5
INDIRECT.EXT 3
255 character limitation of indirect.ext and pull-function 7
INDIRECT.EXT function, PULL function 11
INDIRECT.EXT help 0
what exactly prevents INDIRECT from accessing closed worksheets? 3
Indirect.ext #value! 3

Top