I am trying to use an Excel sheet for Shape Data. But when I import this into Visio it will create new shape data.

Is there a way where It will only update/overwrite only existing shape data and not create new?



I have attached an image where you can see that new data is created with "_VisDM xxx" and "VisDM xxxx". The "Row_xx" is the once that are to be kept.

Right now. I have on the refresh data unchecked the "Overwrite user changes to shape data" So i can manually drag new information into shapes and then go into the Define Shape Data and remove all the new fields that the import creates.

But is there a way to not have this happen?

Thanks.

Attached Images

Screenshot 2024-02-22 133732.png (22.4 KB, 3 views)

I suspect you might be using Visio Professional so I can't test on my machine which is running the Standard version.

What is the method you are using to import the data? If you were using a VBA method to import data I'm sure you could exclude fields from the import.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Yes its business 365 with Visio Professional.

I go trough, Data -> Refresh Data. Here i have a custom import that I can refresh and edit if needed. I have unticked the Overwrite at the moment to not have it screw up the shape data on shapes not needing changes.

I can also do a Custom Import. And it would ask which Columns/Rows to include. But since each shape has slightly different data I want to import all. It will then ask me what identifier I want to use and that's it, nothing else. So i cannot seem to find any option for what I am looking for.

Attached Images

	Screenshot 2024-02-23 070119.png (43.4 KB, 2 views)
	Screenshot 2024-02-23 070317.png (12.5 KB, 2 views)