cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Collector
Kudo Collector

Excel - Sharing with multiple users

Hello Team,

 

I have created an timesheet application from scratch with excel table as database(one drive). We have 30+ users using the same application. In order to achieve viewing the records from the table of excel and adding entries to the table of excel, given full access to all users.

 

Now the problem is, any user(who has access to the file) can modify the entries in excel file of other users or his own entries if he can find the Data storage Excel stored in onedrive which is not acceptable.

 

Do we have any solution to let users can Add entries and view the entries from the same table of excel without modifying the data.

Awaiting for your response.

 

Kind regards,

Naga

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Excel - Sharing with multiple users

Hi @Nagaviswanath,

 

If editing is not allowed, how about removing the Edit Icon (and the Delete Icon) under the Details Screen, and only leave the View and the New Icon under the Browser Screen?

16.PNG

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Kudo Collector
Kudo Collector

Re: Excel file on Onedrive- Sharing with multiple users

Hello @v-micsh-msft

 

My question is not about the UI based one. Sorry for any confusion, i am facing the issue of sharing privilleges of Excel file on One drive (which is acting as data storage for my application). 

 

If i am not sharing the excel file to users, user cannot view the expected results in the view screen and he is getting following error.

If excel is not being shared.If excel is not being shared.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I have shared my excel file to all the users, he can view the results but any user can find this excel file on his own onedrive and having chances of modifying the excel file.

If excel has been shared to the usersIf excel has been shared to the users

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Can you please let me know how to avoid users not to access the excel file directly on his own onedrive?

 

Regards,

Naga

 

Highlighted
Helper II
Helper II

Re: Excel file on Onedrive- Sharing with multiple users

Hi

 

Not sure if this will help:

 

1. Go to OneDrive for Business Site Settings > Site permissions under Users and permissions.

2. Click Permission Levels to and click the Edit permission level to copy the permission level and then delete the Delete Items permission to create a new permission level.

3. Go to the OneDrive for Business document library and then grant the newly created permission level to the required users.

 

 

 

 

 

 

 

Highlighted
Helper II
Helper II

Re: Excel file on Onedrive- Sharing with multiple users

Sorry - ignore above post.  Posted to wrong discussion.

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,602)