Issue connecting multiple next steps in cross functional flowchart from excel template

%3CLINGO-SUB%20id%3D%22lingo-sub-774325%22%20slang%3D%22en-US%22%3EIssue%20connecting%20multiple%20next%20steps%20in%20cross%20functional%20flowchart%20from%20excel%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774325%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20trouble%20with%20connections%20that%20are%20not%20populating%20from%20a%20step%20to%20multiple%20next%20steps%20in%20a%20Cross%20Functional%20Flowchart%20that%20is%20populated%20from%20the%20default%20excel%20template.%20I%20have%20used%20the%20wizard%20in%20Visio%20to%20create%20the%20CFF%20from%20the%20excel%20template%20using%20a%20comma%20as%20the%20separating%20delimiter.%20In%20the%20excel%20template%2C%20for%20the%20'Next%20step%20ID'%20values%20I%20am%20using%20excel%20formula%20with%20absolute%20references%20to%20the%20next%20steps%20e.g.%26nbsp%3B%3D%24B%2420%26amp%3B%22%2C%20%22%26amp%3B%24B%2421.%20I%20have%20turned%20off%20the%20setting%20of%20filling%20formulas%20in%20tables%20to%20create%20calculated%20columns%20and%20also%20changed%20the%20formatting%20of%20the%20table%20cells%20to%20'general'%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20manually%20typing%20the%20next%20steps%20with%20a%20comma%2C%20all%20of%20the%20above%20and%20still%20no%20luck.%20The%20weird%20thing%20is%20if%20I%20change%20to%20just%20a%20single%20next%20step%2C%20then%20when%20I%20refresh%20the%20diagram%20in%20Visio%2C%20the%20connector%20appears.%20Clearly%20it's%20not%20picking%20up%20the%20comma%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20help%20would%20be%20great!%20Cheers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-774325%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EVisio%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1535535%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20connecting%20multiple%20next%20steps%20in%20cross%20functional%20flowchart%20from%20excel%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535535%22%20slang%3D%22en-US%22%3E%3CP%3EI%20seem%20to%20be%20having%20the%20same%20problem%20where%20Visio%20is%20not%20picking%20up%20multiple%20next%20steps%20(comma%20separated)%20in%20my%20Excel%20template%20but%20can%20read%20single%20next%20steps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20checked%20the%20cell%20formats%20but%20have%20not%20been%20able%20to%20resolve%20it%20without%20creating%20a%20new%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20find%20out%20the%20cause%20of%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

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?

 

Some help would be great! Cheers.

 

 

1 Reply

I seem to be having the same problem where Visio is not picking up multiple next steps (comma separated) in my Excel template but can read single next steps.

 

I have checked the cell formats but have not been able to resolve it without creating a new file.

 

Did you find out the cause of this issue?