To link a cell in one spreadsheet to a cell in a different spreadsheet, I went to the destination cell, entered “=” followed by clicking on the source cell. It works once, then refuses to update if the source changes. This worked in Excel. What am I doing wrong?
Are you sure >Data>Calculate>AutoCalculate is enabled?
Yes, it’s enabled.