Forum Discussion

jennifm's avatar
jennifm
Icon for Microsoft rankMicrosoft
Mar 01, 2022

Forms reporting in Excel - can I make it Read-Only?

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?

 

Many thanks!

No RepliesBe the first to reply

Resources