#REF and other errors

Nats.Rudy

I made this sheet with various VLookups and everything worked for about 10 minutes then all the items became errors.

This is an example of one of the formulas giving a #REF error

=COUNTIF({SDI Termination_Details 2025 Range 1}, "2007 - Outlet 1") + COUNTIF({SDI Termination_Details 2025 Range 1}, "2000 - F&B Dept.") + COUNTIF({SDI Termination_Details 2025 Range 1}, "2003 - Stewarding") + COUNTIF({SDI Termination_Details 2025 Range 1}, "2002 - Preparation") + COUNTIF({SDI Termination_Details 2025 Range 1}, "2010 - Outlet 4")

This is a simple formula giving a #BLOCKED error

Anyone knows what is going on with this?

Paul Newcome

I would start with double checking all cross sheet references still exist and are still pointing where they are supposed to go. The place to start with this would be any cell that has the INVALID REF error.