1. instead of typing the actual name of the file, type in 'WC 180405'!B1
instead of the complete path; excel will then ask you to find the file (if a
sheet with the same name in the workbook you are working in is not named WC
180405)

that's it!

"Mike_sharp" wrote:

im using excel 2003

i would like to reduce the size of the following formula as t is too big to
use..

=€˜\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi Report 2005
Swindon.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi
Report 2005 Hemel.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break
Fix KPi Report 2005 Milton Keynes.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI
Reports\[ Break Fix KPi Report 2005 Pangbourne.xls]WC
180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi Report 2005
Llandarcy.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi
Report 2005 Stanlow.xls]WC 180405'!B3 +\\stock\uk\Break Fix\KPI Reports\[
Break Fix KPi Report 2005 Avonmouth.xls]WC 180405'!B3+\\stock\uk\Break
Fix\KPI Reports\[ Break Fix KPi Report 2005 Sunbury.xls]WC
180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi Report 2005
Aberdeen.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi
Report 2005 Sullom Voe.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[
Break Fix KPi Report 2005 Teeside.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI
Reports\[ Break Fix KPi Report 2005 Dimlington.xls]WC
180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi Report 2005
Wytch Farm.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix
KPi Report 2005 Coryton.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[
Break Fix KPi Report 2005 St James.xls]WC 180405'!B3+\\stock\uk\Break
Fix\KPI Reports\[ Break Fix KPi Report 2005 Britannic House.xls]WC 180405'!B3

the path is the same for each file...

thanks