Hi all

What am I missing

='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111

Displays the contents of C111 IN WORK BOOK "Tour Managers
Spreadsheet.xls"tour managers spreadsheet




=("'"&LEFT(CELL("Filename",$A$1),SEARCH("[",CELL("filename",$A$1))-25)&"Road
Managers Package\[Tour Managers Spreadsheet.xls]Tour Managers
Spreadsheet'!C111")

Just displays the text of the formula and not the contents of the C111 CELL

LEFT(CELL("Filename",$A$1),SEARCH("[",CELL("filename",$A$1))-25)

Gives me
C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\


All Help Welcome

Stew