Forum Discussion
Link two workbooks together
Hi! I am trying to link two workbooks together using the "=" in the destination workbook, and selecting the cells from the source workbook. But no data is transferring. Any help would be much appreciated!
2 Replies
Another thing to consider: are both workbooks open in the same instance of Excel? Go to View | Switch Windows - can you see both workbooks? If not, close the workbook you're trying to link to and open it via File | Open of the first workbook.
- Sorry for the obvious questions:
- Do the cells you point to contain anything?
- Is calculation set to Automatic?
