Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Delayed Update?
Hello -
I have a 'dynamic' chart where the source data comes from two drop-down boxes -- the results of these drop-downs cause different results from a VLookUp formula. Currently, when a user changes the drop-down boxes, the graph changes automatically with each box. So, if the user changes both boxes, the graph updates twice -- once for the first box, then again with the second box. I'd like to set this chart to update only after the user is ready, ie pushes an 'update' button. What property needs to be turned off (or toggled?) to prevent the graph from updating until desired? This graph is part of a workbook with multiple other pages --- whatever is done for the graph page should not affect the other worksheets. Any ideas? Thanks, Ray |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Delayed Update?
Graphs are updated each time worksheets/workbooks are calculated. Cause of
the fact that some of my workbooks, in particular my individual machine center production files, has a lot of formulas and charts in them, it gets to be rather lengthy, so for those set of files, I have the Calculation mode set to Manual and Don't calculate before saving. I use a centralized file to do all of the data processing from start to end including calculating each sheet one by one (that is achieved via the Shift-F9 keyboard combination if calculating a worksheet manually). Also, just for the record, I do not use the F9 key by itself within Excel as it's suppose to calculate everything, but found that one to be so incorrect, so I end up using Ctrl-Alt-F9, which forces everything in all workbooks to be calculated, when manually done. How can I have some files calculate automatically and others set to manual calculation? Well this is a bit tricky as you can't have both in the same instance of Excel, thus one of the reasons why I setup files into groups, so as to meet this specific requirement as well as not to exceed the amount of RAM usage allowed within a single instance of Excel (80MB for XL97 and XL2000, 160MB for XL2002/3). Open Excel the first time for those files you want to have calculation take place automatically. Open Excel up the second time either via an icon shortcut to the program, toolbar button or via the StartProgram Files menu. Set the calculation mode to Manual and uncheck the option to calculate before saving. When you close this instance, you may be asked if you want to save Book1.xls (or something like this name). Just click on No unless of course you did something with it that you wanted to save. -- Ronald R. Dodge, Jr. Production Statistician/Programmer Master MOUS 2000 "Ray" wrote in message ps.com... Hello - I have a 'dynamic' chart where the source data comes from two drop-down boxes -- the results of these drop-downs cause different results from a VLookUp formula. Currently, when a user changes the drop-down boxes, the graph changes automatically with each box. So, if the user changes both boxes, the graph updates twice -- once for the first box, then again with the second box. I'd like to set this chart to update only after the user is ready, ie pushes an 'update' button. What property needs to be turned off (or toggled?) to prevent the graph from updating until desired? This graph is part of a workbook with multiple other pages --- whatever is done for the graph page should not affect the other worksheets. Any ideas? Thanks, Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Update a list | Setting up and Configuration of Excel | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
keep value from last update and don't ask to update links | Excel Discussion (Misc queries) |