2 Replies Latest reply on Nov 22, 2017 11:43 PM by Biju Nair

    Filters

    Tim Mullady

      Hello,

       

      I'm trying to use a dashboard with a bunch of tables on it as a filter for an entire workbook. Can anyone help me accomplish this?

       

      It works properly when filteriing data inside its own dashboard and it does filter data in other sheets.  The problem I'm having is when I deselect the filter it doesn't remove the filter from the other sheets.

       

      I have too many filters to show them on the side of a dashboad.

       

      Any information would be greatly appreciated.

       

      Thanks,

       

      Tim

        • 1. Re: Filters
          msa s

          Apply Filters to Multiple Worksheets

           

          Apply Filters to Multiple Worksheets

          • 2. Re: Filters
            Biju Nair

            To apply a filter to select worksheets:

            • On the Filters shelf, right-click the field and select Apply to Worksheets > Selected Worksheets.
            • In the Apply Filter to Worksheets dialog box, select the worksheets that you want to apply the filter. If any of the sheets already contain a filter on the same field, the dialog box will provide details about the filter. If you select the sheet, the current filter will override any existing filter selections.

            Filters that apply to a selection of worksheets are marked with the worksheet icon . Any changes you make to the filter affect all of the selected worksheets.