Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Temporarily highlighting related cells | Excel Discussion (Misc queries) | |||
Temporarily Disable Autocorrect | Excel Discussion (Misc queries) | |||
What macro command to turn off page refresh | Excel Discussion (Misc queries) | |||
Refresh Graph Data | Excel Discussion (Misc queries) | |||
COUNTIF temporarily missed some cells | Excel Worksheet Functions |