Skip to main content

Notifications

Community site session details

Community site session details

Session Id : jylvLppTsaKxe0Jd2oCzon
Power Apps - Building Power Apps
Unanswered

Excel - Sharing with multiple users

Like (0) ShareShare
ReportReport
Posted on 11 Jul 2017 12:43:09 by 86

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

Categories:
  • ianrimmer67 Profile Picture
    66 on 17 Jul 2017 at 10:41:49
    Re: Excel file on Onedrive- Sharing with multiple users

    Sorry - ignore above post.  Posted to wrong discussion.

  • ianrimmer67 Profile Picture
    66 on 17 Jul 2017 at 10:29:05
    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.

     

     

     

     

     

     

     

  • Nagaviswanath Profile Picture
    86 on 17 Jul 2017 at 08:12:55
    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

     

  • v-micsh-msft Profile Picture
    on 12 Jul 2017 at 09:02:13
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard