https://support.microsoft.com/en-us/office/create-an-external-reference-link-to-a-cell-range-in-anot

%3CLINGO-SUB%20id%3D%22lingo-sub-1764023%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-external-reference-link-to-a-cell-range-in-anot%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-external-reference-link-to-a-cell-range-in-anot%3C%2FA%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1764023%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20add%20a%20reference%20to%20a%20cell%20in%20another%20workbook%20in%20a%20formula%2C%20but%20the%20second%20workbook%20will%20have%20me%20go%20to%20that%20cell%2C%20but%20not%20select%20it.%20I%20am%20puzzled%20as%20to%20what%20I%20do%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1764023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1764816%22%20slang%3D%22en-US%22%3ERe%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-external-reference-link-to-a-cell-range-in-%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-external-reference-link-to-a-cell-range-in-%3C%2FA%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1764816%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826380%22%20target%3D%22_blank%22%3E%40Geel__Blauw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirst%2C%20on%20which%20version%20of%20Excel%20you%20are%3F%20If%20desktop%20one%20that%20shall%20work%2C%20not%20for%20Excel%20Online.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Trying to add a reference to a cell in another workbook in a formula, but the second workbook will have me go to that cell, but not select it. I am puzzled as to what I do wrong?

 

https://support.microsoft.com/en-us/office/create-an-external-reference-link-to-a-cell-range-in-anot...

4 Replies

@Geel__Blauw 

First, on which version of Excel you are? If desktop one that shall work, not for Excel Online.

@Geel__Blauw 

In general it shall work. If you start typing in first workbook any formula, let say

image.png

and after that click and select cells in another workbook, you shall see in formula bar that your selections are added to the formula

image.png

Finish the formula and Enter, result is

image.png