Are you sure the formula string is correct - i.e. workbook and sheet names both definitely tie up? Also, I assume the sheet you are trying to add the formula to is not protected and that the source workbook is also not password protected?