I have 2 sheets one and two. one references two. I need to delete the entire sheet two and replace it with another one that is similar. After I do that, one can not from the reference anymore even though sheet two is now there.
The only fix that I have found so far is to go to that cell and press
enter on it again. Refreshing it doesn't seem to work.
Is there any way to get google sheets to automatically find the reference without having to go through and press
enter on everything?