Oct 09 2020 06:24 AM
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?
Oct 09 2020 08:45 AM
First, on which version of Excel you are? If desktop one that shall work, not for Excel Online.
Oct 12 2020 09:08 AM
In general it shall work. If you start typing in first workbook any formula, let say
and after that click and select cells in another workbook, you shall see in formula bar that your selections are added to the formula
Finish the formula and Enter, result is