Shared workbook, 75 users, need faster refresh, (45 minute search fail.)

[Skillhoarder826]

I have a single workbook that will be shared by 75 different users at exactly the same time.

Sheet 1 will be populated by the data from sheets 2 through 76.

MAIN QUESTION: I need this data within seconds of input, by each of the 75 users. Is there anyway to reduce the "auto-refresh" time to below a minute?

What if Question: If used the "connections" command and inputted a 1 minute refresh, would that work after I shared the workbook?

NOTES for the ever-so kind respondents:
-After building this sheet in Google sheets we found that Google Sheets does not allow more than 50 simultaneous users.
(Google sheets is also not currently recognized as "safe" by upper IT)
-Not using any VBA coding or macros in these sheets.
-All user sheets are identical, and no user can input on top of another user on sheet 1.
-This workbook will be replaced monthly.
-Users < average computer users.
-Not all 75 users will be in excel 2016, some are using excel 2010.
-All Microsoft "tools" are considered safe by IT.

The attached photo is a simple example, in reality each user will have 6 questions to respond to.

Options/Thoughts?
Thank you in advance!

[Logit]

,
,

I have a single workbook that will be shared by 75 different users at exactly the same time.

.
.
A few years ago I tried to use Excel in the same manner as your intentions (shared by others at the same time). I learned the hard way that Excel, as a stand alone product, is not able to be utilized in that manner.
Excel can be accessed by one person at a time. User #1 accesses and uses the file, then close the file. Then, User #2 accesses and uses the file, then close the file. Etc, etc.

Having said that, if you find a way of accomplishing your goal, please let me know (seriously). I would like to learn from it.

Interesting that Google can be accessed by up to 50 folks at a time. It must be connected to a back-end product allowing such or is designed differently from Excel ?

[CK76]

You can share a workbook between multiple users in Excel. But it is unreliable and general consensus is that it is best to avoid it.

I'd do something like below, if you must use Excel for some reason.

1. Set up network folder that everyone works out of.
2. Set up individual workbook for each employee (password protect it).
3. Collect info from each workbook (PowerQuery, ADODB etc).

But seems like you want response to survery/questions?
Why not leverage Google Form in conjunction Google sheet? Multiple people can access form at the same time and there is no need to have multiple people editing/sharing Google sheet.

Edit: You can then easily connect to Google Sheet from Excel and create dashboard report etc.

[newdoverman]

I think that a relational database program is what you need. Each user has a sub table of the database. The front end of the database can query any of the tables at any time and only the active records (the ones currently in use by the users) are available. As soon as a record is saved, it is immediately available to be accessed by the front end of the database.

My experience with this was many years ago with Oracle and SQL as the front end and it worked very well.

I think that Excel is not up to the task that you want to accomplish.