Feedback by UserVoice

How can we improve Excel Online? Vote for an existing idea or share a new one.

Give Excel Online a third mode "Data Entry" (without saving the data into the file)

With our Javascript Add-In "data.io" - you`ll find it in the Office Store / AppSource - we could use ONE Excel File in Excel Online as a single "data entry file" for 1000s of users within the same data collection / planning process.

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 ...

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roloc03 shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base