For anyone else as clueless as myself having a similar problem, th
single qoutes should also include the sheet name thus:

='C:\reports\[report5.xls]Sheet1'!$C$1

Cheers, and thanks again for the fast help

--
Message posted from http://www.ExcelForum.com