Importing Data from excel to Visio

[kgarikipudi]

Hi,
I have a question which I'm struggling with but hope one of you guys can help me out.

Is there any way that I can link the shapes in a Visio diagram to an excel table using the Shape ID (developers tab- shape name).
For each shape in the diagram (let's consider shape 1), I've created an ID property (shape sheet- shape data - prop.ID) which has a formula under value column (={guard(ID())}). In Visio shape data window, I'm able to see the value for this shape eg. 563.

Now, when I run the shape report in excel, I get the formula for column "ID" rather than the value 563. I was hoping to export the value instead, and then link the shape using the database wizard.

Is this possible at all or am I better off creating my own IDs.

Secondly, is there any way that a Prop.name created for a shape can change the name of the shape (developer tab - shape name). Again I can use the formula =NAME() to bring out the name of the shape but when I update it in shape data window, it doesn't update the name in developers tab - Name.