I am using the Today() calculation to show the current month in worksheet titles. I am trying to ensure that I don't have to go into each sheet every month and update the month manually. The title reads this:
<Sheet Name> - <MONTH(Today)>
Some worksheets have activity for the month. The title reads:
Sheet Name - October 2016
Some worksheets don't have activity for the month. The title reads:
Sheet Name - All
Is there a workaround for this? The first sheet always has data in it. Could I create a relationship with another sheet or data source in the workbook so that the data read off of that instead of coming up blank?
My understanding is that "All" label in the Title
is triggered when there is no Marks on the view.
I wonder what you would do with an empty view?
Staring on it? Just kidding :-)
Seriously, the above behaviour is by design
and it couldn't be modified / worked around (imho).