Google sheet not refreshing

Hi everyone. I have a google sheet that has been refreshing fine but overnight the refresh failed because I wasn't signed in. Now when I go to refresh after signing in it won't work. After trying to manually refresh, I set an automatic refresh but when the time hit nothing happened even though the request does show under my "Next Refresh" column. None of the new data added is appearing. Wondering what I'm missing... any thoughts are appreciated. thank you.