View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] dough@180solutions.com is offline
external usenet poster
 
Posts: 1
Default Possible to turn off graph refresh temporarily?

Graphs in 2007 are very slow to refresh after refreshing a data
connection. When I remove the 30 graphs in my spreadsheet and refresh
the data connections, it refreshes in less than a second. When the
graphs are present, it's more than 10 seconds. Is there any way
(VBA?) to disable the refreshing of the graphs until after the data
connection refreshes have completed, and then to re-enable them? Kind
of like a "manual calculation" mode for graphs.

Thanks!