internetz wrote:That's not how "view only" works. ( In view only mode, you can't edit anything)
You'd be better off protecting all the sheets and just allowing people to edit cells C4:D8 and B15:D16 on EDIT ME
Of course, you still run into the issue that only 1 person can use the sheet at a time, you can solve this a bit by making multiple "edit" sheets, provided you do all your calculations on the edit sheets. (try moving the calculations at the bottom and then hiding those cells.
here's an example with 4 simultaneous edit sheets : https://docs.google.com/spreadsheets/d/ ... 3uSK0/edit?
Also, why are the first 50 names in the lookup table numbers? did you man for it to be sorted by level instead of alphabetically?
Users browsing this forum: No registered users and 1 guest