Topic: Range error
I am having problems loading an Excel file into Recorder6.
I have loaded loads of Excel files before and also loaded another file earlier today (from the same supplier) and yesterday.
However this one gets hung up after I have clicked Validate Columns on the second screen of the Import Wizard.
I have checked as many things as I can think of in the import Excel file including removing some odd characters from the comments field, changing the formatting of the dates, removing some blank fields in the Determiner column, removing some '&'. Sorting and checking for other oddities. I also blocked and copied the date into a fresh spreadsheet in case there were any other oddities.
I have also saved the file as a csv file and tried loading that (twice).
Then I saved it back again as an Excel file in order to change the date formatting.
I have searched the Forum but not found anything that helps.
Needless to say now I am somewhat stuck...
But I do still love Recorder6, really!
Biological Records Manager
Manx Biological Recording Partnership