Forum Discussion

MarloesNL's avatar
MarloesNL
Copper Contributor
Mar 31, 2025

School forms (grades) totally disrupted

Hello,
We use this form for spelling tests. Each learning block is on a separate page. Something goes wrong somewhere on this page at line 27 or earlier?
As a result, no result counts after that. (block 5 and 6 are empty) The error occurs somewhere in block 4 and we are already at block 6!
We are now transferring all the results to an empty form, but can we not solve this error? The form is protected by the publisher. (so we could not have changed anything in the original?)
They cannot help us with it because it is an outdated version and we will not be switching until the new school year. But that would mean that no one gets a grade...
What is going wrong here? Is there anyone who knows about this and can help us?

Thank you so much!
Marloes Baelemans - De BERK Netherlands

  • It looks like cells have been inserted incorrectly. The formula in AC27 refers to D28 instead of D27.

    And D27 looks different from the cells above and below.

    Does it help if you select AA10:AC10 and then fill down to the last used row?

    • MarloesNL's avatar
      MarloesNL
      Copper Contributor

      Unfortunately I can not change the cells. The program is protected by the maker.  I don't know what to do...

      Ik kan de formule niet aanpassen, ook geen cellen kopieren.

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        I'm afraid you're out of luck.

        If you wish you can attach a copy of the workbook to a private message to me (click on my user picture). If so, I can see if I can do anything with it.

Resources