Excel Chi-squared test - error p-value
I’ve built a model on excel to calculate chi-squared on each of my 8 questions within questionnaire. i'm using chi-squared to understand relationship between scores provided and organisation.

I'm getting an calc. error (#DIV/0) for the p-value because no one from either category scored a zero "0" or a five "5".
Excel is throwing an error in the total expected value which is throwing the =CHISQ.TEST (p-value) calc. into error.

For the =CHISQ.TEST calc. do i therefore need to discount zero and five as categories and reduce my degrees of freedom by 2?
Is that an acceptable method?