Each pupil has a marksheet in Office365 which is shared with them. It is protected so that they cannot edit other than adding comments to say what needs marking next.
Also in 365 I have a class spreadsheet which is linked to each individual’s spreadsheet to give me a summary.
It works fine until I open a pupil’s spreadsheet, at which point the sheet name is stripped out of the formula and replaced with #ref!
I then reinstate the formulas and it’s fine again until I open that pupil’s spreadsheet again!
screenshots here: https://docs.google.com/document/d/1dW8grH6EgDebN8R3Yu7uUNLb9AQWLZVrfSmzTzPQYYo/edit?usp=sharing
Any help gratefully received!
Simon
Also in 365 I have a class spreadsheet which is linked to each individual’s spreadsheet to give me a summary.
It works fine until I open a pupil’s spreadsheet, at which point the sheet name is stripped out of the formula and replaced with #ref!
I then reinstate the formulas and it’s fine again until I open that pupil’s spreadsheet again!
screenshots here: https://docs.google.com/document/d/1dW8grH6EgDebN8R3Yu7uUNLb9AQWLZVrfSmzTzPQYYo/edit?usp=sharing
Any help gratefully received!
Simon