At a guess I would say that you have omitted the # from the sheetname
if it is in the same workbook, and so the formula is trying to open a
file with the name of the worksheet you are trying to jump to.

Can you post your formula here and we'll be able to comment more
accurately?

Pete