refresh shape properties macro

I am using Visio 2003 Standard with SP3. I've linked my visio worksheet to an
Excel table using the link to database wizard. I have several shapes in visio
with fields inserted containing the text which is linked from the excel
sheet.

The values in the Excel spreadsheet will change so I am wondering if there
is a way of creating a macro or vba to automatically update the shape
properties in Visio (rather than going through each one, right clicking and
selecting refresh shape properties). I have tried recording a macro to do
this, but nothing is recorded(!)

Any help would be much appreciated

check below for "data does not refresh..."
al

"alastair" wrote in message
...
I am using Visio 2003 Standard with SP3. I've linked my visio worksheet to
an
Excel table using the link to database wizard. I have several shapes in
visio
with fields inserted containing the text which is linked from the excel
sheet.

The values in the Excel spreadsheet will change so I am wondering if there
is a way of creating a macro or vba to automatically update the shape
properties in Visio (rather than going through each one, right clicking
and
selecting refresh shape properties). I have tried recording a macro to do
this, but nothing is recorded(!)

Any help would be much appreciated