Error when trying to cross reference a sheet

A&W Admin

I'm getting this error when I try to reference a sheet in a formula. It has been happening for a couple of weeks now. I usually get around this by opening the sheet and navigating to the column I need, but it's getting a little tedious.

Lucas Rayala

Hi @A&W Admin, this can happen when you have a very large sheet, or one with a ton of calculations and references. Sometimes it helps to refresh your sheets between trying to add a cross-reference.