Hi folks, newb here! I have a simple Form owned by a group. When I click to "View in Excel", several times I've been notified the spreadsheet is out of sync and asked if I want to sync results to a new spreadsheet. From what I've been able to find online, this spreadsheet is editable and since the form is owned by a group of people, should one of my teammates save edits to the spreadsheet, the next person trying to open the results in Excel gets this prompt.
My questions are:
1) Am I correct in understanding why this happens? If not, please explain!
2) Can I make the reporting spreadsheet Read-Only, so we don't have this issue again? If not, how can I avoid people getting this prompt?