I am having trouble with connections that are not populating from a step to multiple next steps in a Cross Functional Flowchart that is populated from the default excel template. I have used the wizard in Visio to create the CFF from the excel template using a comma as the separating delimiter. In the excel template, for the 'Next step ID' values I am using excel formula with absolute references to the next steps e.g. =$B$20&", "&$B$21. I have turned off the setting of filling formulas in tables to create calculated columns and also changed the formatting of the table cells to 'general',
I have tried manually typing the next steps with a comma, all of the above and still no luck. The weird thing is if I change to just a single next step, then when I refresh the diagram in Visio, the connector appears. Clearly it's not picking up the comma?