Users hope the filter can work correctly with an Excel file having about million of cells.
Sample file: https://drive.google.com/a/potix.com/file/d/0ByoZiMi7jA5DMTZWbDZsRUw5TXc/view?usp=sharing (40 mb)

current workaround

Create a list dropdown with data validation API to show available value and implement the filtering function by query within a database. Then update the quest result to a sheet.