VISIO Shape Data Appears when Linking to External Data

[LeeAnn]

I have customized a VISIO 2007 professional session so that the shape data
holds only one attribute "unique id". This attribute is used to link a Shape
to external data (Excel 2003 spreadsheet) that has 30 data elements
(columns).

This is my question:
When I add a row or change row values in the Excel 2003 spreadsheet and then
refresh the external data, the VISIO shape data changes from only one
attribute to 31 attributes. All values for an item from the external data
are copied into the new 30 attributes. I do not want this behavior. I would
like the shape data to remain as only one attribute ("unique id"). Is
there a setting to prohibit this behavior?

Thanks for your help.
-Lee Ann

 

[David Parker]

When you created the original link, did you open the Select Columns dialog
from the Data Selector, then uncheck all other columns?

 

[LeeAnn]

Thats what I did wrong. So simple!! I have been staring at my screen too
long.

Thanks for all your help, I really appreciate it.
-Lee Ann

 

[LeeAnn]

David,
Maybe not so simple. When I select only the one column, that is all that
shows in the shape data....but... that is also all that shows in the external
data window of VISIO. I would like the 1 attribute to show in the shape data
and all 31 to show in the external data window. Am i missing a step?

Thanks
-Lee Ann