ashleyuk1984
06-25-2018, 06:56 AM
Hi,
I've attempted to contact MS directly for this, but they won't talk to me because I'm not the account admin? :( I'm not sure who is in our company, as it's quite large... So thought I'd try here.
I have also posted this same question here last week, but no response yet: https://sharepoint.stackexchange.com/questions/243829/excel-online-sharing-workbook-between-two-companies
We're currently using Google Sheets to offer a online tracking system for one of our customers.
So for example, in columns A B C, we would enter specific details, and our customer would complete Columns D E F with their finishing details.
However, we don't allow the customer to edit our columns, and visa versa (we don't edit the details in theirs). In Google sheets, this is easy to do. You basically just protect the columns, and allow certain people editing access.
I want to do the same thing, but in Excel Online. I can't find out how to do it?? I've found a guide on how I could do it within, one company... Lock Cells to Certain People But Give Access to others in a Live Excel Online Worksheet (https://sharepoint.stackexchange.com/questions/118905/lock-cells-to-certain-people-but-give-access-to-others-in-a-live-excel-online-wo)
But this wouldn't work with two companies, because I wouldn't have their details in my Group / Usernames.
Is there another way of doing this? Or am I clearly missing something?
In summary:
Company A completes columns A B C (and only views columns D E F)
Company B completes columns D E F (and only views columns A B C)
Neither company, can edit the others data - BUT they are allowed to edit their own columns...
I really want to move away from Google Sheets (because it's very slow on large databases), but this is the only hurdle from preventing me.
Thanks
I've attempted to contact MS directly for this, but they won't talk to me because I'm not the account admin? :( I'm not sure who is in our company, as it's quite large... So thought I'd try here.
I have also posted this same question here last week, but no response yet: https://sharepoint.stackexchange.com/questions/243829/excel-online-sharing-workbook-between-two-companies
We're currently using Google Sheets to offer a online tracking system for one of our customers.
So for example, in columns A B C, we would enter specific details, and our customer would complete Columns D E F with their finishing details.
However, we don't allow the customer to edit our columns, and visa versa (we don't edit the details in theirs). In Google sheets, this is easy to do. You basically just protect the columns, and allow certain people editing access.
I want to do the same thing, but in Excel Online. I can't find out how to do it?? I've found a guide on how I could do it within, one company... Lock Cells to Certain People But Give Access to others in a Live Excel Online Worksheet (https://sharepoint.stackexchange.com/questions/118905/lock-cells-to-certain-people-but-give-access-to-others-in-a-live-excel-online-wo)
But this wouldn't work with two companies, because I wouldn't have their details in my Group / Usernames.
Is there another way of doing this? Or am I clearly missing something?
In summary:
Company A completes columns A B C (and only views columns D E F)
Company B completes columns D E F (and only views columns A B C)
Neither company, can edit the others data - BUT they are allowed to edit their own columns...
I really want to move away from Google Sheets (because it's very slow on large databases), but this is the only hurdle from preventing me.
Thanks