•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can a live MS Forms response spreadsheet be moved into a manger only private channel?
Our take
Managing overtime requests through Microsoft Forms can be challenging, especially when it comes to keeping sensitive data secure. If you’re looking to store your response spreadsheet in a private channel accessible only to managers, you’re not alone. Unfortunately, moving an existing live Excel file into a private Teams channel isn’t straightforward. However, there are alternative solutions to explore, such as limiting Excel access while keeping the Form in OneDrive or creating a dedicated team for managers.
Hi all,
I’m a manager trying to track overtime requests using Microsoft Forms. I have a situation where:
• Staff submit their responses via a Form • I want the response Excel to live in a location only managers can access (so staff cannot see it) • Our Teams setup has a channel with staff and a private manager channel, but Microsoft Forms won’t let me move an existing response Excel into a private channel • I don’t want to create a new Form or rely on Power Automate if possible Our alternatives might be:
• Keep the Form in OneDrive / main channel and limit Excel access to managers • Create a completely new Team for managers only and copy the Form there My questions:
1. Has anyone successfully moved a live Forms Excel into a private Teams channel? 2. Are there any workarounds besides using Power Automate? 3. What do people recommend for maintaining a manager-only live master spreadsheet wit [link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- using MS forms with excelHello! I have a massive spreadsheet that I need to use for lots of reporting. I've tried to pare it down as much as possible for those who have to do the actual data entry, but they are still very overwhelmed by it (they really don't understand how to even use filters to narrow down the scope) and so the data coming out is not reliable. I've never used MS forms in conjunction with excel, but I'm thinking that if I create a form for them just to enter the basics, I would at least have correct data for my analysis piece. The only thing I'm concerned about is that there are updates to entries that need to be made (ie- someone earns an additional level of certification or they drop out of the program). Can this be accomplished with forms? Or am I barking up the wrong tree. I was hoping to get some advice before I start really teaching myself how to use MS forms (any suggestions for good tutorials would be great too). Thank you in advance! submitted by /u/bluellama314 [link] [comments]
- Optimizing data entry in Excel file on SharePoint w/ 5 users: Is MS Forms + Power Automate the way?I want to optimize data entry for an Excel spreadsheet stored on SharePoint, used by 5 data enterers. It has around 300 entries/rows and 17 columns on the main worksheet. 4 other worksheets contain additional variables/columns for the same entries on the main worksheet. 8 other worksheets contain extensive instructions for the systematic literature review we are conducting. Edit: Our current approach has each of us open the Excel file in our desk top app for data entry. The issues I want to solve are: Improved data entry environment: 1) Some cells end up with extensive/long text entries. Users resize cells to optimize their view, but that screws up other people's views. We need data entry solution that allows large data entry areas for certain Excel cells, but not others. 2) Decrease users mistakenly entering data in wrong cell. formatting issues caused by each user doing their own rogue formatting (Despite discussing not messing with formatting in couple of meetings, these people, led by our boss, keep doing it!) excel sheet freezing for short periods of time mouse pointer highlighting cells above the cell to which it is pointing A bit of Googling led me to MS Forms + Power Automate. Would this solve the issues described above and be stable. Is there a better solution? Background Info I'm an intermediate/advanced excel user with experience in VBA, SQL, and stats packages (eg, SAS) working at a large federal agency Excel version: MS 365 MSO v2603 We have MS Forms and Power Automate in-house submitted by /u/tenbsmith [link] [comments]