On first read, I thought you were answering the question which I understood
to be asked (which is not supported in pivot tables to the best of my
knowledge). In actuality, I now understand you to say you were offering an
alternative concept.

I think you are hoping for a perfect solution whereby the row field
LOVs are updated to not display non-entries.

I wasn't, but the OP appeared to be. (if LOV's means the item dropdowns)

--
Regards,
Tom Ogilvy




"MattShoreson"
wrote in message
news:MattShoreson.1vz76h_1127754332.4165@excelforu m-nospam.com...

Do you not see the row fields being updated when you select a different
page field?

I am current on office XP.

I think you are hoping for a perfect solution whereby the row field
LOVs are updated to not display non-entries.

However in the data section of the pivot all info pertaining to the
selected surname in the page field will be filtered.

Tom, I'm sure a man of your expertise/experience will see the principle
I was trying to convey.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=470685