Can you place a secondary file in the subdirectory indicated by the path
which would let you get rid of the path portions in the equation for that
file and then your external equaiton would just have to reference the path
once?
"mike_sharp" wrote:
Thanks for the replies but these wont work, i have tried all 3 suggestions.
any way of phisically shortening that formula?
thanks
"Andy Wiggins" wrote:
1) You could put each of the values into separate cells and then reference
those cells in your formula.
Or
2) If the source data is all from the same file, create the formula in the
source file and reference the result.
--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
"Mike_sharp" wrote in message
...
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