I see "Refresh Conflicts" "The following Shapes were linked to rows that were removed from the data source" but as stated, this is a copied Excel workbook, where the sheet's column names are identical, but with new row contents.

Think DB table with first row having record names, then rows below having content... visio is using this content to name and fill in details for multiple shapes.

The connection to the new workbook succeeds, and the excel "column" names (first row) are identical -

Why is this impacting the relationship between the data and the visio shapes?

Further - using the "automatically link rows to shapes" wizard, does not repair, even though the data column and shape field are correctly mapped.

Thanks to all in advance.

• Edited by sidn33 Wednesday, June 10, 2015 2:13 PM

in the way of some background, visio only uses the column names once. When data is linked to the shapesheet visio uses the recordsetid and the columned, both of these are numeric and attached during the datalinking process. Visio does not go back and check to see if they are ever altered (that's why if you change a column position after the linking the data no longer is applied correctly). If you load a new recordset it is assigned a new recordsetid and column information, this requires relinking of the data and shapes because from the visio perspective all of it is new. Visio used to do a poor job of cleaning out old data in shapes, so duplicate names was a real issue but since it didn't use the names (merely the id pointers) it's not an issue under the covers.

al edlund