raytrace
11-20-2014, 12:35 AM
The problem is quite simple. I have prepared a read only sheet with data linked from other sheets on the same workbook.
When the data changes in the the other worksheet it is replicated in the read-only sheet as well, as it should.
If I have placed a filter on a column in the read-only sheet and then change the data on the source sheet the filter does not change. This behavior is acceptable.
However, if I want to update the read-only worksheet (which has to be Protected) to reflect the changed data I have to go through the whole procedure;
1. Select the auto-filter arrow of the column that needs to be refreshed
2. Go to Text/date filter item in the menu
3. Select Custom Filter and the press the Ok button.
Is there a keyboard shortcut that would simply do the above ?
Please note, the worksheet has to Protected/read-only.
Thanks.
When the data changes in the the other worksheet it is replicated in the read-only sheet as well, as it should.
If I have placed a filter on a column in the read-only sheet and then change the data on the source sheet the filter does not change. This behavior is acceptable.
However, if I want to update the read-only worksheet (which has to be Protected) to reflect the changed data I have to go through the whole procedure;
1. Select the auto-filter arrow of the column that needs to be refreshed
2. Go to Text/date filter item in the menu
3. Select Custom Filter and the press the Ok button.
Is there a keyboard shortcut that would simply do the above ?
Please note, the worksheet has to Protected/read-only.
Thanks.