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 ?