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

%3CLINGO-SUB%20id%3D%22lingo-sub-3238656%22%20slang%3D%22en-US%22%3EForms%20reporting%20in%20Excel%20-%20can%20I%20make%20it%20Read-Only%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3238656%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20folks%2C%20newb%20here!%20I%20have%20a%20simple%20Form%20owned%20by%20a%20group.%20When%20I%20click%20to%20%22View%20in%20Excel%22%2C%20several%20times%20I've%20been%20notified%20the%20spreadsheet%20is%20out%20of%20sync%20and%20asked%20if%20I%20want%20to%20sync%20results%20to%20a%20new%20spreadsheet.%20From%20what%20I've%20been%20able%20to%20find%20online%2C%20this%20spreadsheet%20is%20editable%20and%20since%20the%20form%20is%20owned%20by%20a%20group%20of%20people%2C%20should%20one%20of%20my%20teammates%20save%20edits%20to%20the%20spreadsheet%2C%20the%20next%20person%20trying%20to%20open%20the%20results%20in%20Excel%20gets%20this%20prompt.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMy%20questions%20are%3A%3C%2FP%3E%0A%3CP%3E1)%20Am%20I%20correct%20in%20understanding%20why%20this%20happens%3F%20If%20not%2C%20please%20explain!%3C%2FP%3E%0A%3CP%3E2)%20Can%20I%20make%20the%20reporting%20spreadsheet%20Read-Only%2C%20so%20we%20don't%20have%20this%20issue%20again%3F%26nbsp%3B%20If%20not%2C%20how%20can%20I%20avoid%20people%20getting%20this%20prompt%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMany%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3238656%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

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!

0 Replies