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!
Please check if you have applied filter to a single sheet, Selected Sheet, datasource?