Login
Register
4Matrix 4Matrix Support Knowledgebase 4Matrix Desktop: Importing Data
Unhandled Exception error after completing spreadsheet import
Suggested knowledgebase articles:

Summer Holidays Support Hours

From Monday 20th July to Wednesday 2nd September, our support services (tickets, live chat and telephone) will be available from 9am to 3pm.

We will provide extended support hours during results days as follows:

  • Wednesday 12th August (GCE Results): 8:00am to 5:00pm
  • Thursday 13th August (GCE Results): 8:00am to 5:00pm
  • Wednesday 19th August (GCSE Results): 8:00am to 5:00pm
  • Thursday 20th August (GCSE Results): 8:00am to 5:00pm

 

Unhandled Exception error after completing spreadsheet import

This is usually related to either the formatting in the original spreadsheet or a corrupt map file.

In Excel, copy the sheet you're working with and paste the data into a new sheet using Paste > Values. This will strip the file of all formatting and show any hidden columns. Make any changes that may now be required. 

Refresh 4Matrix using File > Open Windows > Close All Windows and start the import again.

If it continues to fail, and you're using a map file, please try again and disregard the map file. As a quick test, try importing just 1 subject column (with your basic pupil details) and check that it works. You could also create a new map file if you have a series with the same subjects using Admin > Edit Subjects > Create Map from within the relevant series.

Was this article helpful? Yes | No

Article Details

Article ID:
66
Category:
4Matrix Desktop: Importing Data
Date added:
06/12/2016 17:05:37
Views:
1,059
Rating (Votes):
(13)

Related articles