Filters within a Table (Not Working)

Hi, Can anyone PLESAE help this is driving me crazy!

So I have a table in which the filters are not working properly. It started by omitting the final few rows for the selection but as time goes on its now omitting large portions of the final section of the table. The table is:

- 2481 rows long
- 233 Columns wide
- Multiple formulas
- Multiple conditional formatting

I have tried

- Taking off the filter and putting it back on
- Changing the table to a range then converting it back again
- Ensured there are no blank cells

It also seems strange that although there is just one table in the workbook with charts ad pivots being driven off this table the workbook is 6,129KB. I have seen this issue coming up on the threads before but none of the suggestions seem to work for me.

Any help is appreciated.

Thanks

Thanks very much but it wont let me as I within a table. The filter option is greyed out.

Thanks Sandy its not protected or Grouped... I need to keep it as a table rather than range as with the range you cant sort he data multiple times without messing up the formula....

Thanks anyways!

I know, sometimes Excel Table is better then range, but sometimes you need to check WHY you cannot filter it.

After open the file and select any cell inside the table you have Filter gray or not?

Yes, the filter is greyed out....?

so try option under my EDIT (post #4) and check

Sorry yes I tried that....... Its still greyed out

If the new workobook with copied tab isn't too big and not TopSecret, could you attach it?

I wish..... Its a work thing and I'm not allowed to share!