Home

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
Highlighted
jasonshaw
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.

 

 

Related Conversations
Ribbon or right clicking will not go further out
51218 in Excel on
0 Replies
How to automate a timesheet template?
fishfish31 in Excel on
1 Replies
Excel Worksheets and templates
Christine_R in Excel on
6 Replies
Web links no longer works after data refresh
DataQue in Excel on
0 Replies
Percentage of attendance
linrojy in Excel on
7 Replies
Grouped data visibility in formula builder
Bram_Elfrink in Excel on
1 Replies