Hi @Jason Hawthorne ,
Did you type =Sheet1!A1 directly in cell? Only =Sheet1!A1 in cell?
Where did you save the file?
Did this problem appear in all Workbooks or specific Workbook?
I suggest you save Workbook to desktop and create a new Workbook.
Try 2 ways to enter the =Sheet1!A1, type and reference.
Please be a bit more precise to explain your problem or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.