incomplete export to xlsx

Discussion created by ZWW on Jan 30, 2016
Latest reply on Jan 30, 2016 by ZWW



I use Filemaker pro 14.0.4 and Excel for Mac 2011 14.6.0.


I want to export 283 records with names and addresses to xlsx. The set has been sorted on last name.

After export I find only 233 records in xlsx.


It turns out the exported xlsx file contains only one record for every last name.

The missing 50  records contain names  that occur more than once in the original file.


When I sort the set on a number that is unique to all records I get all 283 records.


It is not serious, but if one is not aware of this it may create problems.


Anybody knows more about this ?


Many thanks