Give Excel Online a third mode "Data Entry" (without saving the data into the file)
Unfortunately this doesn`t work due to several reasons:
1. For this purpose it would be perfect to do the data entry in "View Mode" and not in "Edit Mode" (since we don`t want to save any data in the excel file itself).It would be a third mode "Data Entry Mode" since now it is not possible to enter any data in "View Mode" (and for many processes this is for sure the right thing).
2. BUT, if we use "Edit Mode" then Excel Online saves ALWAYS the entries from a user -> the next user opening the file does not get a clean data entry form but sees the automatically saved entries from his predecessor. And the current entries from his co-authoring collegues using this same "data entry file" at the same time.
3. Excel Online does not support XLTX File Format (Template) which would not solve but mitigate the issue (since every use would get at least automatically his/her own copy of the template ...)
I´m afraid the only way to work with Excel Online in our scenario is to create 1000 copies of the template for 1000 users and give each user his/her own data entry file. Then tell every one that the file itself is not important after finishing the data entry since all the data is already written to a cloud application (via the data1.io Add-In).
I call it a "THIRD MODE for DATA ENTRY" that we need - besides the existing Viewing and Edit Mode - and it could be invoked with a URL-Parameter. This would be a great field for Excel Online to generate additonal business value especially for large organizations.
Maybe there are other scenarios / other Add-In vendors who work on similar usecases for Excel Online ...