Hello. I'm using excel 2007. There're several sheets containing lots of charts drew from data quoted from a same sheet in the same book. Since the charts in the sheets are quite many each time I update the original data and click another sheet open I have to wait a second before the charts in that sheet all complete their automatical update. Thus It's quite inconvenient that with each sheet I have to wait a second before I'm able to see the update result. Any ideas to get all the sheets update the charts in them before clicking them open? Thanks a lot!
Bookmarks