Thanks Andy,

I searched high and low through all of the ribbons, didn't think to look
there!!!!

Regards

JaneH

"Andy Pope" wrote:

Hi,

It's part of the filtering.

Click the dropdown on Row field.
Value Filters...
Top 10

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JaneH" wrote in message
...
In previous versions of Excel there was a sort and top ten feature. Ihave
been able to sort my pivot tabel in 2007, but I cannot find the top ten.
Is
it still available in this version?