Topic: Problem with exported data
This year I have been experiencing difficulties exporting data to Excel for one of the two VCs for which I am Recorder. The data are imported to R6 in the same way and the imports have worked and I value the checking that R6 does so that the data are 'clean' when imported.
I am using Excel 2016 and am not very impressed with it. I used to extol the virtues of Excel for many years (at work I had to use Lotus 123 or whatever it was called - a pig to use) but the latest version of Excel has had many stupid problems like, at times, not letting me copy and paste. Because of this I am not sure if the issue is an Excel problem or if there is a problem getting the data out of R6 and I would very much welcome a view.
I have just exported c 303k records for VC51 without a problem. I created an export file of c 316k records for VC50 but Excel would not, or could not, open the file and I don't understand the reasons. The message mean nothing to me. They are shown in the attached file.
Is the problem in R6 and how could I correct it? Not knowing what the problem is does not help me to deal with it alone.
I will be very grateful for any guidance as to what is happening.
All the best, Ian