Question

how we can use multiple workbook for linking a cell​

Answer 1

Explanation:

With your formula still open, click over to the other workbook. Then, click on a cell in your second workbook to link up the two Excel files.