The issue with your formula is that it is missing the file extension ".xls" after the workbook name "Test". Also, the exclamation mark should come before the sheet name, not after. Here's the corrected formula:

In this formula, replace "A1" with the cell reference you want to link to in Sheet3.

1. When you click on the cell with this formula in Sheet1, it will take you to cell A1 in Sheet3 of the same workbook.