Okay, more testing.... might not be the table. I narrowed it down to the last column. If that column is taken out, or formulas left as static values, then the filter works just fine. I am not sure why you need that column, as the formula will return the same for every cell. So for you this should be a simple fix. Doing this (taking out that column) will fix it - and you can leave your range as a table. Very interesting though. I'll do some more research on this.