Are you publishing it on to the server? At server level you want the default selection as Current Year..right?
Yes.I am going to publish later.Is there that option ?
3 of 4 people found this helpful
see, the thing is that when you publish the workbook on to the server, you select the filter as 2016 (current year) and then publish. By this way, it will be published according to the 2016 year and this only will be its default state!!
So anytime when any user interacts with the work book on server and then signs out, and when new user logs in, he will also see the workbook again in the default mode only i.e. 2016 year as filter!
So make the selection as 2016 and the publish!(2016 will then be the default state!)
let me know if this helps