In ArcGIS 10, I'm attempting to locate a script (or write one) that will automatically refresh the link for an excel graphic imported as a linked table into layout view. I have many mxds and many objects per mxd that need to be auto-updated when the map document is opened (so that they reflect the current data in the table).
On a related note, I'm also trying to prevent the object from auto-resizing when refreshed (since the layout is static, they need to stay the same size).
Ideas? Help? Directions?
Thanks in advance!
Kate
