When you select a cell in the PT a special tab appears on the ribbon called Pivot Table Tools
Click the Options Tab and click "Change data source"
You will now see it ( there are probably other ways)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|