Google Sheets "Unresolved sheet name" even though sheet exists [closed]

Question

Every time I refresh my Workbook, I get a bunch of "Unresolved sheet name" errors even though the sheet exists. If i select the cell and hit enter twice the error goes away and the data populates.

Anyone encountered this before?

Thanks in advance.

Answer 1

Order of operations matters.

I've run into the "Unresolved sheet name" error previously when copying sheets over into a new spreadsheet.

If sheet A refers to sheet B, make sure you copy over sheet B first. Otherwise sheet A won't be able to find sheet B, and even re-writing the formula may not work.