K Kathy Smith Jan 15, 2004 #1 when i run a filter the number of records being filtered does not display on the status bar.
G Gareth Jan 15, 2004 #2 have you of formulae which 'look' at the data being filtered? I found that if you have SUMPRODUCT or other similar functions calculating the data being filtered than the status bar does not work. If you set Calculation to Manual it will work, but remember to switch back to Automatic afterwards. Gareth
have you of formulae which 'look' at the data being filtered? I found that if you have SUMPRODUCT or other similar functions calculating the data being filtered than the status bar does not work. If you set Calculation to Manual it will work, but remember to switch back to Automatic afterwards. Gareth
