D
dough
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!
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!