I have an access 2007 database that I created to link to an excel file that gets refreshed nightly. Then I have visio 2007 charts that are generated off the access query that creates the layout file that is needed for Visio. Works perfectly except that when the file and the query is refreshed, it does not update my visio charts. Does anyone have any idea how I can automate the visio charts to refresh when they are opened. The VP is suggesting we maintain visio charts manually and that would be a nightmare. Please HELP

I appreciate the help.