The Form is recording all responses for sections 1+2+3, but not for section 4. There are mandatory questions in section 4 which have to be completed. When testing, this all works fine and the user can submit the Form.
When looking at the Excel sheet, the Form is recording data in the previous 3 sections UNTIL section 4 where there is 0 data recorded.....even though I have filled it in several times, and as stated, there are mandatory questions.
The responses are showing up in the Forms results dashboard, but this is no use as the data all links together and I need to extract it.
Note: I do not have access to OneDrive or SharePoint, so cannot work around as has been suggested previously.
**Edited: responses are also showing up in the "view results" section, so it's ONLY Excel not showing the data**