I have a large spreadsheet that is pulling data from an ODBC source and throwing it into a table. From that table I am creating a pivot chart and a pivot table. The data I want my sales people to see is the pivot charts. Here is the issue. I have all the tables and charts setup to autoupdate on open. What I want them to do is update every 10 minutes or so. Here is the other issue. My data "pull" takes about 30-45 seconds so my charts are refreshing before all the new data is pulled. So basically I have to go back and refresh the charts after doing a refresh all. I have began to build some really large programs in excel with 20 or so different sheets pulling and linking data. I feel getting into VB is going to be a must for me in the future.