Can anyone help me with this problem? I am trying to restrict the items available in one page field depending on what is selected in a previous page field, using whatever means available. I have tried VBA from various posts on this site and even a combination of validation lists using named ranges and the indirect function plus VBA, all to no avail.

I am using Excel 2000. My pivot table has two page fields named "RGM" and "CAM". The data in those fields is text as both fields contain the names of people. There are many CAMs to one RGM. There will never be one CAM to two RGMs. The pivot table is linked to a dynamic named range.

Any help will be much appreciated. Please let me know if anymore info' is required.