I have 5 worksheets each with several tabs. I use “=” then with the mouse point to the cell I wish lined. The data goes in and I save it. On the next day, I make changes to the linked sheets and they do not update other sheets linked to the cells. I have added all the sheets in the Security screen as trusted locations Recalculate automatically is set and protections are off and calculate automatically for trusted sites is on.
but when i SAVE THE spreadsheet and open it again on the next day the data does not automatically update to changes I have made. and i get REF or some other error - no code.