0

On a Spreadsheet I have created two different Sheets named Sheet 1 and Sheet 2 and also created two Users with permissions to access specific sheets. For example: User 1 to access Sheet 1 User 2 to access Sheet 2

Scenario: User 1 and User 2 access the file using their specific credentials to see their assigned Sheets. (File saved in SharePoint) A VB Code has been applied to show them the login screen to enter Username and Password before accessing the file.

Problem: Let's say User 1 logs in, he will be able to see only Sheet 1 - this is currently happening but the moment User 2 logs in to view Sheet 2, User 1's sheets gets replicated by Sheet 2 whereas it should stay on Sheet 1 only and ONLY User 2 should be able to see Sheet 2.

Trying to find a solution to work on MS Excel with multiple users

Mayukh Bhattacharya
  • 12,541
  • 5
  • 21
  • 32
user244269
  • 111
  • 1
  • 1
  • 3
  • What does your code look like? – Notus_Panda Jul 31 '23 at 07:08
  • 2
    *MS Excel with multiple users* I don't think Excel is the right approach for this. I know you are working in SharePoint but Excel can't handle properly multiple users. – Foxfire And Burns And Burns Jul 31 '23 at 07:09
  • You can use separate Excel files (every user has their own) as front end and connect them to some kind of backend (DataBase for example) - while still not being optimal, it probably is one of the only ways to create a multi user excel app that reliably works. - You could use google sheets - which works great with multiple users (and can be extended with GAS - which is basically JS) - but with the cloud based solution (Google-Sheets) you'd have to check if privacy laws and data protection would be an issue. – Lord-JulianXLII Jul 31 '23 at 11:09

0 Answers0