Did you check the "macro security"? This option is under File-->Options-->Trust Center, Trust Center Settings. If it is set to "Disable all macros without notification" the macros in macro enabled workbook will be omittedn and won't work.
hi, I am using office 365 for Mac and I don't see this option to find the trust center under: File as suggested.
I did however changed it somewhere else but still when I "create a family tree" only names of grandparents are created and none of the other columns are updated.