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

Hi sidn,

Based on your description, when you using Link Data to Shapes option in Visio and you got the message Refresh Conflicts .

If you refresh a diagram after a row has been removed from your data source, either you can choose to remove the shape that it is linked to  so your diagram continues to match the data  or you can keep the shape, even if the data source no longer has a row linked to that shape. For solve this issue you can try this method:

1. In the Refresh Conflicts window, in the list of shapes, select the shapes that you want to apply one of the following commands to.
2. Click one of the following:
   1. Delete Shape to delete only the selected shapes
   2. Delete All Listed Shapes to delete all of the shapes with missing rows
   3. Keep Shape to keep only the selected shapes
   4. Keep All Listed Shapes to keep all of the shapes with missing rows

Please Note: The Delete Shape and Keep Shape commands are unavailable (appear dimmed) if no shape is selected in the list.

Try this method and check if it works for you.

Hope its helpful.

Regards,