The first thing that occurs to me is that the longest thing in your formula
is the name of the Excel file. Shorten that and you have a lot of characters
left over? I'm also thinking that possibly a SUMPRODUCT() formula may work,
but I'd have to really dig into your formula, rip it apart and see what it's
doing in the individual areas. And, if I recall correctly, SUMPRODUCT() may
be one of those formulas that doesn't work across workbooks anyhow. But
memory doesn't serve me well this morning, and I am pressed for time at the
moment.

I know you'd probably rather not change the name of the Excel file, but you
might consider opening up both workbooks, then saving the one with the long
file name under a new, shorter name. Then continue to do updates/data entry
into the one with the long name, but just before opening this one to do data
examination, copy the long file over the one with the short name, thus
bringing it up to date.

"JDB" wrote:

The formula below works sort of ok, but I now need to change the formula to
reflect what will be Augusts results, I'm getting the error formula too long.
Is there a way that this can be truncated at all?

The formula is as follows - the sheet contains results broken down by team
and individual in rows. If anyone can think of a better method for showing
results, I'd be glad of that too!

=SUM('I:\CCR\SAM\IPP\FCC Team B\July 2007\Emma Ward\[FCC Evaluation Tool -
Team B - Emma Ward.xls]Sharron Dyke'!$F$32+'I:\CCR\SAM\IPP\FCC Team B\July
2007\Emma Ward\[FCC Evaluation Tool - Team B - Emma Ward.xls]Sharron
Dyke'!$F$66+'I:\CCR\SAM\IPP\FCC Team B\July 2007\Emma Ward\[FCC Evaluation
Tool - Team B - Emma Ward.xls]Sharron Dyke'!$F$100+'I:\CCR\SAM\IPP\FCC Team
B\July 2007\Emma Ward\[FCC Evaluation Tool - Team B - Emma Ward.xls]Sharron
Dyke'!$F$134+'I:\CCR\SAM\IPP\FCC Team B\July 2007\Emma Ward\[FCC Evaluation
Tool - Team B - Emma Ward.xls]Sharron Dyke'!$F$168+'I:\CCR\SAM\IPP\FCC Team
B\July 2007\Emma Ward\[FCC Evaluation Tool - Team B - Emma Ward.xls]Sharron
Dyke'!$F$202+'I:\CCR\SAM\IPP\FCC Team B\July 2007\Emma Ward\[FCC Evaluation
Tool - Team B - Emma Ward.xls]Sharron Dyke'!$F$236+'I:\CCR\SAM\IPP\FCC Team
B\July 2007\Emma Ward\[FCC Evaluation Tool - Team B - Emma Ward.xls]Sharron
Dyke'!$F$270)

Regards,

JDB