Hello

I am adding cells from different workbooks that are on a network drive and thier location cannot be changed. This formula is too long part of the location never changes how would i shorten this:

='S:\Corporate Services\Financial Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and Activity Monitoring\Stephan\[Stephan''s Enforcement Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financial Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and Activity Monitoring\Mike\[Mike''s Enforcement Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financial Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and Activity Monitoring\Frank\[Frank''s Enforcement Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financial Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and Activity Monitoring\Carole\[Carole''s Enforcement Stats.xls]Enforcement Stats 2005'!F15 'S:\Corporate Services\Financial Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and Activity Monitoring\Angie\[Angie''s Enforcement Stats.xls]En

The constant is
'S:\Corporate Services\Financial Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and Activity Monitoring\

Thanks,
Mike