Refer to a workbook

Solved
André Roussel -  
 André Roussel -
Hello,

I am going to ask a question that I think is a bit simpler than usual:

Is it possible to refer to a cell in a different Excel workbook in a formula?

Thank you in advance for your answers.

Best regards,

André Roussel

Configuration: Windows / Chrome 59.0.3071.115

3 answers

  1. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello André Roussel

    To refer to another workbook
    Both workbooks must be open
    In the second workbook, in the relevant cell, enter ""="" and go to the first workbook, click on the corresponding cell, and validate by pressing ""enter""
    This cell will take the value from the first workbook
    Both workbooks must be in the same folder
    Check if this works for you?

    --
    Practice makes perfect. - It's at the foot of the wall that one sees the mason - one always learns from their mistakes.
    1
  2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    yes, of course, but the link will only work if the source workbook is open
    select your cell
    write your formula by clicking on the source cells in the other workbook and the addresses will automatically appear
    best regards

    --
    The quality of the answer mainly depends on the clarity of the question, thank you!
    1
  3. André Roussel
     
    Thank you! That's really super convenient!
    0