You could use event code on the sheet that contains the data validation
dropdown. For example, if the dropdown is in cell C2, and the pivot
table is on a sheet named Sales Pivot, right-click on the sheet tab for
the data validation sheet and add the following code:

'========================
Private Sub Worksheet_Change(ByVal Target As Range)
Dim pt As PivotTable
Dim pf As PivotField
Dim pi As PivotItem
Set pt = Worksheets("Sales Pivot").PivotTables(1)
Set pf = pt.PageFields("Region")

If Target.Address = "$C$2" Then

Application.EnableEvents = False
For Each pi In pf.PivotItems
If LCase(pi.Value) = LCase(Target.Value) Then
pf.CurrentPage = pi.Value
Exit For
End If
Next pi
Application.EnableEvents = True

End If

End Sub
'=====================

excel misc wrote:
Is it possible to link the page field in a pivot table to a cell in
the spreadsheet?

I want to select a value from a validation list in cell, c3 on sheet1
and have this value be the page field value.

Thanks



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html