2014-06-11, 19:40 #1
- Join Date
- Jun 2003
- New Jersey
- Thanked 0 Times in 0 Posts
Automate Organizational Charts in Visio
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.
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!