←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Input tool for multiple users

Our take

Managing data input for multiple users can be challenging, especially when privacy and accuracy are paramount. Your concerns about the usability of the current tool are valid, particularly regarding data integrity and simultaneous access. While traditional Excel can pose limitations in this area, exploring innovative solutions designed for collaborative environments may offer a more effective approach. These solutions can empower frontline staff to input data securely and efficiently, ensuring that everyone has access to the information they need without compromising privacy or functionality.

Sorry if this is a dumb question,but I've taken over a project at work for a major offer we are running. The project manager has built a tool that has an input where frontline staff enter an ID number and it tells them whether the person associated with that ID has benefited from the offer before.

It's been vetted for data privacy and accuracy, but I'm pretty sure it is unusable. The plan was to upload it to an intranet SharePoint site for use for thousands of frontline users, include it in training.

If I'm not mistaken, I don't believe there is a way to fully lock it down so it can't be edited, and even if you can leaving just one input cell, I'm not sure there are ways to have multiple users use it at the same time without seeing eachothers inputs.

Is there a way in excel to do this?

Thanks

submitted by /u/phuzee
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#Excel compatibility#real-time data collaboration#Excel alternatives#rows.com#big data management in spreadsheets#conversational data analysis#financial modeling with spreadsheets#intelligent data visualization#real-time collaboration#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#input tool#multiple users#ID number