Top 10 Filtering not working

I've got a PT with about 600 rows and 20 data columns, five grouping columns and I can't get filtering to work. I thought it might be because I was linking to a query (worksheet) to get my data, but I did a Paste Special of my data to a new WorkBook and it still does not work. This table also does not sort one column properly either. I tried rebuilding the table with the pasted data and it still does not work. If I build a simple PT with 25 rows and one grouping column it works.

Excel is 2003, s/b up to date as it's a corporate version.

It is likely some of the data you have that you think are numbers are in fact text.

Try taking a copy of your data and the copy a 1 from a spare cell, highlight all your data and do a Paste Special>Values+Multiply. This should convert any text numbers to actual and try rebuilding your data

I had some Nulls that it might have been picking up as 'Text', so I converted these to zeros, but it still does not work. There is one other column that is sometimes used for grouping (not in this PT) that is a mix of text and numbers, but as I said it's not used in this PT.

I'm guessing you tried my remedy as just typing zeroes will not overcome the 'stickiness' of text formatted cells?

If you would like to attach the workbook or email me on nick underscore hodge at zen dot co dot uk I'll take a look