Forum Discussion

MonMin's avatar
MonMin
Copper Contributor
Dec 03, 2021
Solved

Problem with creating external reference to another workbook

Hello   I tried looking for a solution to my problm but no luck. When trying to link a cell from different workbook I used the =cell adress method. It work when both workbooks are opened but when I...
  • cris_no_h's avatar
    Dec 03, 2021
    under Fromulas/Calc Options, make sure it's on auto.
    Review your settings in: File/Options/Formulas and Advanced/Link Handling and
    make sure under When calculating this workbook "Update links to other documents" is checked. review if you need "save external link values"

Resources