I have a Pivot Table that holds Sales Order Line information for all open Sales Orders (SalesLine PT). I have another Pivot Table (ItemPrice PT) that holds pricing information keyed on part number from different vendors. I would like to be able to trigger a change on ItemPrice PT as I scroll throught the part number field on SalesLine PT. I tried doing it with connected sliders but excel complains about both tables containing duplicate values. Any ideas would be greatly appreciated.