Filter Shows "Not available" Instead of Expected Values
Published: 11 Apr 2013
Last Modified Date: 01 Sep 2017
IssueWhen you open a workbook, filters in the view might display the following message:
Navigate to Analysis > Filters > Enable Auto Update.
Ensure Automatic Updates for worksheets are not turned off. For more information, see Automatic Updates.
CauseAutomatic updates are disabled.