I have a SharePoint Online survey with ratings. When I export it to Excel none of the rating responses are showing up. So it shows the rating question/statement but all of the response fields are empty. When I look at the survey in SP I can see that all responses are filled in. I've googled to no avail. Thanks!
I think what is happening is when you export the survey a query is sent to your Excel application. This query is then executed within the environmnet of your excel user?
If this user has access to your Survey list then the items that this user has access to is exported.
Can you give some more detail on the user accounts that you are using? Are you running Excel with the same user ((user that is logged into your PC) as the user that you are viewing the results with in SharePoint?
The owners of the list have full control and are getting no results when trying to export. I'm an O365 admin and also get no results when exporting. So yes, the same user is logging in and using Excel and SharePoint.