If the other workbook is not open then you would need VBA for this, if it is
open

=IF(ISERROR(INDIRECT("'[Workbook.xls]Sheet5'!$A$1")),"Does Not
Exist","Exist")



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Alex" wrote in message
...
I need to check from the Workbook1 whether the SheetName exists in the
Workbook2. (I have many workbooks to check.)
I'm trying to use
=IF(ISERROR('C:\[Workbook2.XLS]SheetName'!$A$1),"No","Yes")
It's working but if the SheetName has been created in the Workbook2 I have
#REF! in the Workbook1.

Probably, there is a better formula to do this.
Please, advise.

Thanks