Hello,
I have a matrix question in my survey. It has 5 likert points. The last likert point is "I don't know". I just noticed that this has a red cross mark near it and the "exclude from analysis" is checked. So I just had a look at the excel format of recorded responses. When the user selects "I don't know", this is recorded as empty cells. Is there any way to revert this and get "I don't know", rather than empty cells? Although, i can see that the user selected "I don't know" when I view the response through qualtrics.
Thanks a lot.
Solved
Exclude from analysis problem
Best answer by ahmedA
Just uncheck "Exclude From Analysis". 
ahmedA The responses are already recorded, and the "I don't know" cells are empty. Will this method work and those cells will be restored with "I don't know" again?
In case of a normal survey, where you just have the questions, then yes. If you are referencing a survey, then I'm not sure. The best way to check whether they will be restored or not, is to look at the PDF files of the response. If it shows that "I don't know" is selected. Then it will be restored. Otherwise, not.
+22https://www.qualtrics.com/community/discussion/comment/32751#Comment_32751Yes, this works retroactively. So once you remove exclude analysis from that option, just go to data and analysis and refresh the page.
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.