search

JordanScarrott / StudentExcelSheet

A fully dynamic, backwards compatible Excel sheet for recording the marks for a class of students.
0 stars 0 forks source link

INVALID Cells not updating ocasionally #2

Open JordanScarrott opened 4 years ago

JordanScarrott commented 4 years ago

Sometimes the test cells that return "INVALID MARK" don't update. Then you don't get any feedback on the front page. I think this is because of the way that the "INVALID MARK" is calculated and might have something to do with the ISOVERMAX() function that I made. There is a circular reference there somewhere.

There are two solutions:

  1. Periodically update each of the exam sheet "INVALID MARK" cells to update them when they fail.
  2. Resolve the circular reference to prevent the error from occurring again.

I can't seem to figure out why the circular reference is happening though so I will attempt #2, and if I can't resolve it, I will do #1.

JordanScarrott commented 4 years ago

I noticed that when I delete tests, these formulas don't update and I get this error. Deleting students updates these cells again