1 Reply Latest reply on Mar 13, 2017 2:40 PM by Deepak Rai

    Resetting Filter on Worksheet Affecting Other Worksheets

    Teresa Wright

      I have several worksheets connected to a single data source (MS Access).  On one worksheet I want a YOY comparison (select 2016 & 2017).  On another I want 2017 only.  Why is it when I set the filter on one sheet, the other is automatically changing?  I've disabled Auto Update (Filters>Disable Auto Update). 

       

      Thanks for your assistance!