how-to-lock-data-filter
Last Update: 3/27/2017
Graphs and analytical results generated from filtered worksheet data will update if data or filter conditions change. Therefore, if you want to do side-by-side comparisons of graphs or analysis results created with different filter conditions of the same worksheet data, you need to use the Worksheet: Copy Columns To menu command (the colcopy X-Function) and copy the relevant columns that are needed in analysis and graphing from the source worksheet to a new worksheet, then "lock" the filter in the new worksheet. This freezes a particular result so that you can make changes to the original worksheet data or filter condition and generate a new result.
For more information on how this works, see the tutorial: Lock Filter with Analysis or watch the video: Dynamically Update Graphs with Filter Conditions
See Also: FAQ-862 How do I update a data filter when I make changes to my data?
Keywords:lock, auto-update, recalculate, worksheet, colcopy, copy columns, worksheet