#REF on all my Sheets

Samuel Dowdy Jr.

Why am I getting this across all my sheets. It just recently started in the last week or so and everything referencing one sheet

Andrée Starå

Hi @Samuel Dowdy Jr.

I hope you're well and safe!

It seems like a reference is missing.

Have you checked the Activity Log for clues?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Samuel Dowdy Jr.

I check the formula and all the references were there. What should I be looking for? Should I look in the sheet its referencing?

Andrée Starå

@Samuel Dowdy Jr.

Start with checking the Activity Log for clues to what might have happened.

Samuel Dowdy Jr.

I have and I don't see anything that stands out.

What's odd is that the cells were working until I submitted a webform to the sheet the cells are referencing. Then everything went to #REF.

On other sheets, sometimes the cells work and others it doesn't. But the problem is always the master sheet its referring too.

Andrée Starå

@Samuel Dowdy Jr.

Strange!

I'd be happy to take a quick look and see if I spot the issue.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Andrée Starå

@Samuel Dowdy Jr.

It works for me, and I don't see any errors.

Can you check on your side again?

Samuel Dowdy Jr.

Its odd its working for me now too. This is what commonly happens. Look at the sheet I just shared

Andrée Starå

@Samuel Dowdy Jr.

It can also be because your solution is resource-heavy.