Question

What is External Sheet Reference? Write the syntax to apply it?

Answer 1

Answer:

Create External Reference. On the View tab, in the Window group, click Switch Windows. Click North. In the North workbook, select cell B2. Type a + Copy the formula to the other cells. Note: if you see another alert, click Update or Don't Update. If you didn't update the links, you can still update the links here.