Family tree template

%3CLINGO-SUB%20id%3D%22lingo-sub-833953%22%20slang%3D%22en-US%22%3EFamily%20tree%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833953%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20a%20template%20that%20I%20found%20in%20excel%20templates.%20It%20is%20macro-enabled.%20When%20I%20changed%20the%20names%20and%20added%20to%20it%2C%20the%20family%20tree%20doesn't%20populate%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-833953%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834009%22%20slang%3D%22en-US%22%3ERE%3A%20Family%20tree%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834009%22%20slang%3D%22en-US%22%3EDid%20you%20check%20the%20%22macro%20security%22%3F%20This%20option%20is%20under%20File--%26gt%3BOptions--%26gt%3BTrust%20Center%2C%20Trust%20Center%20Settings.%20If%20it%20is%20set%20to%20%22Disable%20all%20macros%20without%20notification%22%20the%20macros%20in%20macro%20enabled%20workbook%20will%20be%20omittedn%20and%20won't%20work.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2297635%22%20slang%3D%22en-US%22%3ERE%3A%20Family%20tree%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2297635%22%20slang%3D%22en-US%22%3Ehi%2C%3CBR%20%2F%3EI%20am%20using%20office%20365%20for%20Mac%20and%20I%20don't%20see%20this%20option%20to%20find%20the%20trust%20center%20under%3A%20File%20as%20suggested.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20did%20however%20changed%20it%20somewhere%20else%20but%20still%20when%20I%20%22create%20a%20family%20tree%22%20only%20names%20of%20grandparents%20are%20created%20and%20none%20of%20the%20other%20columns%20are%20updated.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20idea%20%3F%20Many%20thanks%3C%2FLINGO-BODY%3E
Occasional Visitor

I am using a template that I found in excel templates. It is macro-enabled. When I changed the names and added to it, the family tree doesn't populate  

2 Replies
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.

Any idea ? Many thanks